Saturday, May 5, 2012

How to get first character of a string in SQL?


SUBSTRING (my_column, 1, 1)
because it is Standard SQL-92 syntax and therefore more portable.

No comments: