Post reply

function in SQL to identify whitespace

  • March 30, 2004 at 9:13 am

    #84659

    I was wondering if there was a function in SQL Server to identify white space in the way the null works:

    Case itemA is null then

     

    Case itemA is null then

     

    Is there a function in SQL to identify white space?

    the way that null works:

    CASE itemA IS NULL THEN

    or

    isNull(itemA,'')

  • March 30, 2004 at 11:35 am

    #501130

    Take a look at CHARINDEX(). It can be used for just about any character or stream of characters.

    K. Brian Kelley
    @kbriankelley

  • March 30, 2004 at 11:46 am

    #501136

    Thank. I will try that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply