Post reply

T-SQL select statement modification

  • May 13, 2009 at 8:06 am

    #993744

    Whenever you embed an quoted text within another quoted text, you have to add two quotes instead of one.

    This statement

    ISNULL( NULLIF( LTRIM( RTRIM( [state] ) ), '' ), 'false' ) should be changed to

    ISNULL( NULLIF( LTRIM( RTRIM( [state] ) ), '''''' ), '''false''' )

    --Ramesh

Viewing post 16 (of 15 total)

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