Tuesday, November 9, 2010

Select Substring Query in sql server

SELECT
(CASE WHEN LEN( address) > 25
      THEN SUBSTRING(address,0,25)
 ELSE address END
)as address
FROM emp_details

0 comments:

Post a Comment