ASP.NET and SQL SERVER Tricks
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment