SQL need to check null or empty string

[B_Hodge]

Can any body tell me that how do i check in my Stored procedure if the information passed is null or empty in SQL, in order to insert the new value or need to keep the old one. Can any body tell me that how can i do it? Does any body knows about it? Kindly provide me the correct solution for the above issue.

[Praetor]

According to me, i think you're facing with character fields, where you have an empty string that is different from a NULL value of a character field.

A NULL value represents the absence of a value for a record in a field (others softwares call it also a missing value).

An empty value is a "field-formatted" value with no significant data in it.

[Katty]

For that you need to follow the below steps mention.

Create Table #Temp (column1 varchar(50))

INSERT INTO #Temp VALUES (NULL)

SELECT * FROM #Temp

UPDATE #TEMP
SET column1 = ''

SELECT * FROM #Temp

[kelfro]

I think you can prepend AppraisalResponseHistory. in front of detail but that will be the same.

Detail is null or LEN(Detail) > 0 is checking the wrong thing it should be
Detail is null or LEN(Detail) = 0 -- null or length of 0