SQL Server Forums - query to distinguish €Œ , €œ

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

query to distinguish €Œ , €œ

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Keshaba
Yak Posting Veteran

India
52 Posts

Posted - 05/27/2010 : 03:40:17

I am writing a query in MSaccess I am facing a problem,in distinguishing text with €Œ , €œ

SELECT distinct Symbo
FROM Link
WHERE Voucherno='000001' And VoucherType='DP' And upd=0 And Symbo='€Œ';
My result is:
Symbo
€Œ
€Œ
€Œ
€Œ
€Œ
€Œ
€œ
€œ
€œ
€œ

But there is difference between 2 text €Œ , €œ How shall i write the query to distinguish both.Can anybody help..........

Keshab

webfred
Flowing Fount of Yak Knowledge

Germany
8515 Posts

Posted - 05/27/2010 : 04:41:38

If this is a T-SQL query then you can use a case sensitive collation but in MS Access I don't know.

No, you're never too old to Yak'n'Roll if you're too young to die.

Keshaba
Yak Posting Veteran

India
52 Posts

Posted - 05/27/2010 : 07:12:25

How can i do that in T-Sql

Keshab

webfred
Flowing Fount of Yak Knowledge

Germany
8515 Posts

Posted - 05/27/2010 : 07:43:09

First in a query window in your database run:
exec sp_help Your_databasename_here

Then you can see in the second resultset the name of the collation for your column named Symbo.
Post the name of that collation here please.

No, you're never too old to Yak'n'Roll if you're too young to die.

webfred
Flowing Fount of Yak Knowledge

Germany
8515 Posts

Posted - 05/27/2010 : 10:34:40

http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/

No, you're never too old to Yak'n'Roll if you're too young to die.

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.08 seconds.