Trying to get a wildcard

<i><b>Originally posted by : Scott Arango (sarango@ford.com)</b></i><br />i am trying store an if... then procedure saying that if it finds this as a name (drd____) then<br /> ... = false. But my problem lies trying to get the wildcard to work. if i type the name like:<br />if form_id = "drdscott" then.. , it will use the statement, but if i try = "dtd%" or use = "dtd*"<br />it won't recognize the id.<br /><br />

<i><b>Originally posted by : Steve Loof (smloof@aol.com)</b></i><br />you have to use the LIKE keyword<br /><br />SELECT * FROM person<br />WHERE name LIKE 'dtd%'<br /><br />------------<br />Scott Arango at 4/17/2001 7:17:42 AM<br /><br />i am trying store an if... then procedure saying that if it finds this as a name (drd____) then<br /> ... = false. But my problem lies trying to get the wildcard to work. if i type the name like:<br />if form_id = "drdscott" then.. , it will use the statement, but if i try = "dtd%" or use = "dtd*"<br />it won't recognize the id.<br /><br />