WHERE xxx = wildcard

[Ike]

I have a hard-coded select statement wherein I can change certain values.
Sometimes, I want to be able to select ALL the records. For example, suppose
I am SELECTing something with a 'username' column only I want to be able to
select ALL usernames (so I dont want to use IN or BETWEEN). is there a means
I can use to specify something along the lines of SELECT.....WHER E username
= % ? Can I use a wildcard with this somehow? Thanks, Ike

[Aggro]

Ike wrote:

I have a hard-coded select statement wherein I can change certain values.
Sometimes, I want to be able to select ALL the records. For example, suppose
I am SELECTing something with a 'username' column only I want to be able to
select ALL usernames (so I dont want to use IN or BETWEEN). is there a means
I can use to specify something along the lines of SELECT.....WHER E username
= % ? Can I use a wildcard with this somehow? Thanks, Ike

select * from tablename where username like '%';

select * from tablename where username like '%endofname';

select * from tablename where username like 'startofname%';

select * from tablename where username like '%middleofname% ';

[Bob]

And then there's Select * from tablename

i.e no where clause at all

"Aggro" <sp**********@y ahoo.com> wrote in message
news:6Q******** ****@read3.inet .fi...

Ike wrote:

I have a hard-coded select statement wherein I can change certain values. Sometimes, I want to be able to select ALL the records. For example, suppose I am SELECTing something with a 'username' column only I want to be able to select ALL usernames (so I dont want to use IN or BETWEEN). is there a means I can use to specify something along the lines of SELECT.....WHER E username = % ? Can I use a wildcard with this somehow? Thanks, Ike

select * from tablename where username like '%';

select * from tablename where username like '%endofname';

select * from tablename where username like 'startofname%';

select * from tablename where username like '%middleofname% ';