Select using *

[dun263]

Hello everybody,

I have the following sql statement:

Select * from Table where Something >=1* and Something <=5*

The result includes records with 1*, but not also the results with 5* - only with 4*.

What am I doing wrong?

SK

 

[jbenson001]

what does you data look like?

 

[dun263]

column contains account numbers from 0 to 9, values are strings.

SK

 

[SQLDenis]

what happens when you do this?

Select * from Table where Something >='1*' and Something <='5*'


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/