Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-11-17 : 18:56:19
|
| Pls, what d this query return if applied on char type (string type)select * from myTable where myNameColumn Between 'B' AND 'E'would return all the names that start with : B, C, D, E like these:Bob, Chris, Edward, Davidbut not :Marry, Jean....or how does it work exactly when applied on string type but only putting one character in the search.Thanks. |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2006-11-17 : 18:58:50
|
| sory, i just had the idea to try it and it workedso yes the answer is that it displays the names that stat with a letter between B and EThanks a lot |
 |
|
|
|
|
|
using BETWEEN with only one character