function in SQL to identify whitespace

• rodrigub

  Say Hey Kid

  Points: 682

  More actions

  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,'')

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  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

• rodrigub

  Say Hey Kid

  Points: 682

  More actions

  March 30, 2004 at 11:46 am

  #501136

  Thank. I will try that.