Thanks Amitthat helped resolve the error. just so you know I have to do a workaround for empty space( null)For somwhor when I do '' query converts it to null and it replace the whole string with nullthe workaround I use the following ( leaving single space and using LTRIMVIPReplace(@firstName,'-',L...