Simple one

hi,



i have a column called Country and the records are blank when its U.S.A



when i retrieve them i have this code



and when i do Response.write residentcountry its blank can someone tell me whats wrong







residentcountry=rs("Country")



if residentcountry="" then

residentcountry="U.S.A"

End if



Response.write residentcountry





thanks,



charles

it's probably NULL, not empty. such code will solve this:

thanks shadow forgot abt isnull



have a nice day



charles