1748067 Members
5437 Online
108758 Solutions
New Discussion юеВ

select with wild card?

 
Ratzie
Super Advisor

select with wild card?

I am trying to get a select statement working with TOAD.
I thought the % is a wild card, but when I run it I get nothing in return where I know I should.

select * from table
where bld = '%floor'


Am I doing it right?
3 REPLIES 3
Geoff Wild
Honored Contributor

Re: select with wild card?

The _ is a wildcard for any single character.

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Ratzie
Super Advisor

Re: select with wild card?

what if it is more than one charecter.
405.1

I am looking for anything that has the . in the column.
Ratzie
Super Advisor

Re: select with wild card?

I have figured it out.
like!!!


where bld like '%.%'