locked
Retrieving characters from a string RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    you can extract first three characters of a column by

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