>>>Within an update command, I need to replace a portion of a string in a Text field. So, basically, I am looking for the equivalent of this in SQL Server:
>>>
>>>

>>>UPDATE MyTable SET MyField=STRTRAN(MyField," \ ","\")
>>>

>>
>>REPLACE()
>>
>>

>>UPDATE MyTable SET MyField=REPLACE(MyField,' \ ','\')
>>

>
>How do you get this to work if your field name is description ?

Put the field into the brackets. [Description]

UPDATE MyTable SET [Description] =REPLACE([Description],' \ ','\')

If a field is SQL Server reserved word, you need to use []. You can use it for regular fields as well. In other words, you can use it every time.