trying to read first 9 positions of a Char(50) datatype column

84 Views Asked by At

I am trying to compare two columns one with Column1=Char(9) and other with Column2=Char(50). Need to do Column1=Column2, but I need only 1st 9 positions of column2 to be read to do the equality function. Please help.!! tried trim function as well

tried trim function as well. Please help with solution

1

There are 1 best solutions below

2
On

In a Datastage Transformer substring functionality is done via

columnname[1,9] 

which means from position 1 cut 9 characters.