var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Begins With
I am trying to reduce the number of fax numbers I have in my access database querying out all numbers except 6 area codes.
I have tried to do:
WHERE FaxNumbers BEGINS WITH 972 OR 817 OR 214;
but it doesn't work, what am I doing wrong?
Try the following query
select phone from users where phone like '301%' or phone like '201%' or phone like '212%';
Thanx and Regards
I have tried both the command BEGINS WITH 972 or 817 or 214 or 903 and LIKE 972% or 817% or 214% or 903%, and neither work. I get no results even though I know that there are some in there.
Can anybody help me?
Could u post the command u r using to query the DB.
I think I got it to work.
I used * instead of %.
Good luck with your query.