i'm using SQL Server 2005 :

i wrote one query like :

select invoice_num from IM_INVOICE where invoice_num between 'a' AND 'izzzzzzzzzzz';


Ideally we are expecting the record from 'a' to 'i'. & all should be small letter . BUT we are getting the record that is in CAPITAL LETTER as well.But here we are comparing only with Small Letter.

Anyway when we are comparing like bellow:
select invoice_num from IM_INVOICE where invoice_num >= 'a'
                                AND invoice_num <= 'izzzzzzzzzzz';

The problem is still the same. I'm geting the invoices that is in Capital Letter along with small letter.


Could anyone help me out.....? i'm Struggling alot with this..!

Thanks & Regards
Anant

__________________
anant

Thinking out loud, Sql is making the comparation in text and not binary (that is what you want). I don't have a clue about it, but you should investigate that way...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========