Hi to all,
With all wasting anyone time...
For SQL 6.5 I need to figure out a select statement like
select * from Table where column1=column2 and
column2<9999
But the column1 is a int and colomn2 is a varchar...
I have to get all results where are equal for less then 4 digits...

I know how to do it in SQL 2000 but its not the same...

Can someone help

Thanking you in advance...
Rino

Hmmm werid.

SELECT * from TABLE where column1 = Convert(int, column2) and convert(int,column2) < 9999

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
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 planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

ahhh
I had the first part but never thought of putting it to the second part too...
"and convert(int,column2) < 9999"
Work great thanks...

No problem glad it worked out for you.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
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 planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========