W3D Problems
world wide web development problems asp net php html xhtml css javascript jquery w3dproblems
Monday, August 26, 2013
How to check if a string is null or empty (length 0) sql server
First convert empty value to null using "
nullif
" then use "
isnull"
to switch
SELECT
Isnull
(
NULLIF
(
string1
,
''
)
,
string2
)
AS
String
.......
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment