How to drop the first 4 digits from an insert statment
Hi there, i need to insert records from an excel file to a sql database,
On excel i have a column with this number format:
44556612345677, i need to insert into sql2005 only the 12345677, i dont need this:445566;
and another column in excel has this format:
1234567, and i need to insert in sql like this:00001234567
i tryed to use the SSIS and this function with derived columns but not working.
this is the expression i tryed:
right([Connecting Phone Number] , LENGTH([Connecting Phone Number] ) - 6) '0000' + right([Current Phone Number], LENGTH([Current Phone Number]) - 6) as [Current Phone Number]
thanks
__________________
bx
|