https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867005#M863668 I am trying to get a select statement working with TOAD.<BR />I thought the % is a wild card, but when I run it I get nothing in return where I know I should.<BR /><BR />select * from table<BR />where bld = '%floor'<BR /><BR /><BR />Am I doing it right? Sun, 24 Oct 2004 16:39:28 GMT Ratzie 2004-10-24T16:39:28Z https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867005#M863668 I am trying to get a select statement working with TOAD.<BR />I thought the % is a wild card, but when I run it I get nothing in return where I know I should.<BR /><BR />select * from table<BR />where bld = '%floor'<BR /><BR /><BR />Am I doing it right? Sun, 24 Oct 2004 16:39:28 GMT https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867005#M863668 Ratzie 2004-10-24T16:39:28Z https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867006#M863669 The _ is a wildcard for any single character.<BR /><BR />Rgds...Geoff Sun, 24 Oct 2004 17:43:16 GMT https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867006#M863669 Geoff Wild 2004-10-24T17:43:16Z https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867007#M863670 what if it is more than one charecter.<BR />405.1<BR /><BR />I am looking for anything that has the . in the column. Sun, 24 Oct 2004 18:23:07 GMT https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867007#M863670 Ratzie 2004-10-24T18:23:07Z https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867008#M863671 I have figured it out.<BR />like!!!<BR /><BR /><BR />where bld like '%.%' Sun, 24 Oct 2004 18:28:33 GMT https://community.hpe.com/t5/operating-system-hp-ux/select-with-wild-card/m-p/4867008#M863671 Ratzie 2004-10-24T18:28:33Z