Hi can any one help me how to remove space in a string. i know trim function.but it is not working.remove function is there but how to use it?delimeter is space but it is not taking.
ex;string is like bang lore
i want banglore:i used like this remove(string,' ') it is not working
If you have a VarChar and the TRIM() result looks like it still has spaces then odds are you don't have spaces. Try writing the result of "Convert(' ','?',In.Column) to a peek stage - do you see question marks or spaces?
thanks alot,still i heve one more query that i have a transaction data withoutspaces i need to make lookup with master data which might be exist with spaces so that is the case look up will fail how can i prevent this situaation actually this is my requirement .