Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jweizman
Starting Member
27 Posts |
 Posted - 2001-05-01 : 14:47:19
|
| HiI have read the SQL Team article about the use of COALESCE instead of dynamic SQL.I like the idea.However it doesn't work for me...I have some fields :FirstName LastName DOBirththey are all nvarchar(50).Sometimes one of the fiels is NULL sometimes 2ex :FirstName LastName DOBirthJonathan Null NullJohn Smith NullJohn Doe 06/04/56when calling the SP presented in the site article with 'John' it will return only the 3rd line.. because on the second one there is a null and i search on the 3 fieldsAny idea ?I have read some answers posted in the forum but did not work for me...JonathanBut I want the second line too ! |
|
|
|
|
|
COALESCE and ISNULL