Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Expression Help RE: SSIS Expression Help
rocky_498
SSCertifiable
Points: 6532
More actions
March 19, 2015 at 2:56 pm
#1785226
Here is the solution, May be someone want to know...
LEN(CellPhone) == 10 && !ISNULL(CellPhone) ? CellPhone : LEN(OtherPhone) == 10 && !ISNULL(OtherPhone) ? OtherPhone : OID