Hello I need help on how to do this more efficient. I will need to write a store procedure to validate an address which contains special characters
Address is like :
Street : Las Ñipas 4264
So i need to remove the Ñ and replace it for N
I was reading to use collate SQL_Latin1_General_CP1253_CI_AI but i am not sure how to use it since it caused me more trouble it added some spaces .
Could you please advise on what will be the best way to do this ?
- This topic was modified 11 months, 2 weeks ago by Mond.