I have a table called Field in my SQL Server database. The table has a field called "Units".
I have a batch script which inserts a lot of things into here using OSQL and one of the things entered is the pound sign (£). When OSQL runs the queries, it converts the £ sign to -ú instead.
What I need to have is a separate batch file which updates all this at the end
e.g.
update field set units = '£' where units = '-ú'
This sql above works fine if I run in a query but through OSQL it doesn't work.
I have found that editing the file in DOS mode in TextPad allows me to put in the DOS symbol for £ and that bit works ok, but I don't know how to replace the -ú part so I can do the replacement.
Any ideas?