Hi,ArndW wrote:Please remember that an empty string, "", is not null. ...
Look at the data types . If both are same, then
no need to use stage var/constrain for this. give it in derivation as if IsNull(phone_no) Then N Else Y.
Moderators: chulett, rschirm, roy
Code: Select all
Trim(In.Col)#''