Thursday, August 1, 2013

to get left 4 characters from a string in sql

To get the left characters from a string using sql server

QUERY
SELECT LEFT('ASPDOTNET',4)

RESULT
ASPD

No comments:

Post a Comment