locked
Retrieving characters from a string RRS feed

  • Question

  • I need to compare the first 3 characters of a string column to another string column.

     

    How do I select the first 3 characters from the string in the column

    Thursday, July 31, 2008 11:26 AM

Answers

  • you can extract first three characters of a column by

    SELECT  SUBSTRING(ColName, 1,3) FROM TableName
    Thursday, July 31, 2008 11:43 AM