Re: SQL Server varchar not liking HTML entities?

2004-08-02 Thread Damien McKenna
On Jul 31, 2004, at 3:04 PM, Dave Watts wrote: When you say you're doing this from Enterprise Manager, do you mean you're using the Query Analyzer application? Or are you actually editing the table's contents from Enterprise Manager itself? Within the Enterprise Manager itself.This is via

RE: SQL Server varchar not liking HTML entities?

2004-08-02 Thread Dave Watts
Within the Enterprise Manager itself. This is via RDS from my Mac to the Windows server. I would recommend you try running the query through Query Analyzer instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This

RE: SQL Server varchar not liking HTML entities?

2004-07-31 Thread Dave Watts
I'm trying to clean up some old data where they have e.g. the TM symbol embedded in the data.The odd thing is that in the Enterprise Manager when I am editing the field (after doing a show-all) and I change the TM to trade; I am told: The value you entered is not consistent with the data

SQL Server varchar not liking HTML entities?

2004-07-30 Thread Damien McKenna
I'm trying to clean up some old data where they have e.g. the TM symbol embedded in the data.The odd thing is that in the Enterprise Manager when I am editing the field (after doing a show-all) and I change the TM to trade; I am told: The value you entered is not consistent with the data type