Hi -

I need to run the following sort of statement:

Code:
Select * from emailatt 
where emailatt.FileName = '\\slsEFX\Exports\SO4514.pdf'
Thing is, \ is the escape symbol & therefore the above returns 0 records, even though I copied the file name from a row in the table.

Anyone know the trick?

TIA