title: Select the first N digits of an integer
body: <p>I have a SQL Server table ("Activities") which has a column containing an ID, e.g. "10553100". This is the activity ID and is composed of two parts -> first 4 digits indicates which project it belongs to, and the last 4 digits indicates which sub project. </p>
  
  <p>I need to extract the project number from the <code>activityId</code> column (aka the first 4 digits). Is it possible to do this using a simple SELECT statement in SQL?</p>