- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Thanks Amit
that 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 null
the workaround I use the following ( leaving single space and using LTRIM
VIPReplace(@firstName,'-',Ltrim(' ')) +'-' + VIPReplace(@lastName,'-',Ltrim(' '))
Thanks everyone