>>>>>Is there a function in SQL Server that works like STRTRAN in VFP? I have the following line in VFP that I need to convert to T-SQL:
>>>>>
>>>>>
>>>>>cString = STRTRAN( cString, '&' + 'amp;', '&' )
>>>>>
>>>>>
>>>>>Any suggestions on how to do it? TIA.
>>>>
>>>>See REPLACE function in BOL
>>>>
>>>>select replace (@cString, '&' + 'amp;', '&' )
>>>
>>>Thank you.
>>
>>No problem. There is a WiKi page showing how to map VFP functions into SQL Server, I hope you have a reference to it.
>
>I do have this WIKI page; I didn't think this function is covered there but I will check again. Thank you.
It is indeed covered there.
If it's not broken, fix it until it is.
My Blog