Page 1 of 1

query using LIKE synntax

Posted: Wed Dec 17, 2003 4:20 am
by pelegk2
i want to make a query that will match astring that will start with a certain number(5 for exaple)
and that must be at laset 2 letters length :
53
53455

so what do i do?
select * from tblXX where val like '%5?%'
what do i do?
thanks
peleg

Posted: Wed Dec 17, 2003 4:36 am
by JayBird
not sure if this will work

Code: Select all

select * from tblXX where val like '5_%'
Mark

Posted: Wed Dec 17, 2003 4:44 am
by pelegk2
i will check it