Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team
I have a column Code where I am getting some dummy value as hyphens '-------------'. I want to remove that trailing hyphens row while loading the data.
Please help
Thanks in advance
Can you show few sample data points to see how exactly they might look like
Sristi, We can achieve these number of ways
Load * from Table Where Not WildMatch(FieldName, '--*')
Or
Load * from Table where FieldName <> '---';
or could be more ways, If you provide little more information