Return ntext from function
-
Hi, Sql server does not support ntext in function. Is there any way to use ntext in function? I have a condition where a ntext column value if not exist in one table then i have to select it fom another table. Thanks in Advance
-
Hi, Sql server does not support ntext in function. Is there any way to use ntext in function? I have a condition where a ntext column value if not exist in one table then i have to select it fom another table. Thanks in Advance
I wasn't aware of this limitation with the NTEXT datatype. So maybe I'm barking up the wrong tree here, but have you tried using the COALESCE(value_which_may_be_null, value_to_return_in_case_of_first_value_being_null) function? There's also the CASE statement, if you want to check for an empty string as opposed to a NULL. I've been coding in Orcle for some months now, so apologies if i've missed the point of your question.