Saturday, 5 January 2013

SQL LEN function and IF ELSE

SQL Query to check length of the field and using IF ELSE

IF
LEN(@UserLike) >0

BEGIN

UPDATE tbl_Kukoo

SET UserLike = @UserLike

where ID=@ID

END


LEN(@UserLike) >0   - to get length of SQL field.

No comments:

Post a Comment