Saturday 16 February 2013

Fetching larger String in SQL Server :its Based on ASCII codes

SQL server sorts string column on the basis of their ASCII codes for example I have a table BOOKS



if i want to get only those books which are greater than c++, it will return only those records whose starting alphabet is greater in ascii than c like



similarly 











No comments:

Post a Comment