» SQL Server 2005
» sqL Server 2000 (RSS)
Sorry, but there are no more tags available to filter with.
Mladen Prajdic has created a SQL equivalent of the C# IsNotNullOrEmpty I looked at it and thought that there was way too much code
Here is my version, you pass an additional parameter in to indicate whether you want blanks only to count or not
CREATE FUNCTION dbo.IsNotNullOrEmpty(@text NVARCHAR(4000),@BlanksIsEmpty bit)