Home Forums SQL Server 2008 T-SQL (SS2K8) Evaluating Spaces RE: Evaluating Spaces

  • February 11, 2011 at 3:08 pm

    #1285923

    Here is a bit a kludge,

    Declare @Header VarChar(500)

    Set @Header = ' ' --this is 2 spaces

    IF (REPLACE( @Header,' ', '|') = '||') --replaces each space witha pipe delimeter

    BEGIN

    PRINT 'It is 2 spaces' -- just checking if it works

    END

    ELSE

    PRINT 'Your guess is as good as mine' -- no it is not working

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]