Trim on variable having space as value

[johnthomas]

I was trying to use trim function on a variable which has spaces . It seems it does not return a null . Any suggestion on the function to be used for the issue , so that it should return a null if the values is spaces

[thebird]

Remeber - an empty string is not a null.

So, trimming a string which has spaces will not return a null - but an empty string - ''

If you need it to return a null, then you would have to explicitly set it to Null based on a condition of the sort -

Code: Select all

If trim(input.col)="" then SetNull() else trim(input.col)

Make sure that your input field is a Varchar.

[DSguru2B]

Dont give any space between the two double quotes or it will always look for a single space which trim is getting rid off and it will never SetNull.

[johnthomas]

In Case there is no space between double quotes , is the value after the trim is going to be null

[DSguru2B]

Yes. Read the statement. If (after trimming there is nothing) then SetNull else (trim the incoming value of spaces and output the value). Better yet, test it.