substring function
Posted: Wed May 09, 2007 3:51 pm
Hi,
I have a field 'X' varchar(22).
I need to use substring function [11,4].
substring function is working.
If I have a charecter in the 4 digits value I have to write it to a rej file in the transformer otherwise I need to write the record in the someother file.
I tried AlNum function but it is not working.
Any other idea.
Thanks
I have a field 'X' varchar(22).
I need to use substring function [11,4].
substring function is working.
If I have a charecter in the 4 digits value I have to write it to a rej file in the transformer otherwise I need to write the record in the someother file.
I tried AlNum function but it is not working.
Any other idea.
Thanks