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 |
|
sjb
Starting Member
3 Posts |
 Posted - 2006-09-26 : 03:37:35
|
| Hi everyone, I just want to know if it's possible to do a partial SELECT query on a db column...Like... do a select where 'name' starting with 'jo' and then the result set will bring back all the names starting with 'jo', displaying 'john', 'johan', 'jonathan', etc....thanksSJB |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-26 : 03:44:42
|
| somthing like this Select * from tabelname where name like 'jo%'Chirag |
 |
|
|
sjb
Starting Member
3 Posts |
Posted - 2006-09-26 : 03:55:08
|
| thanks, I'll give it a try....But, another thing... hoe can I give it a variable value.So that anything can be searched for? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-26 : 04:01:28
|
| [code]Select * from TblWhere Col like @var + '%'[/code]Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
sjb
Starting Member
3 Posts |
Posted - 2006-09-26 : 04:07:18
|
| thanks.... |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
|
|
|
Partial SELECT statement