Like in sql statement

[firebreath67]

I am using like in sql to access a Access database and it just reads right though the whole database. It does not display what i asked for

 

[PHV]

what i asked for
And you asked what ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[firebreath67]

I am asking it to make sure that the four numbers with the wild card in front are a phone number and then populate a form

 

[PHV]

And you asked how ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[firebreath67]

select * from [Bill To Customer] where CompanyPhone Like '% " & Session("PhoneN") & "'"

 

[PHV]

Provided you use ADO and Session("PhoneN") is empty, then you should select all rows where CompanyPhone is not null.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

How are ya firebreath67 . . . . .

Apparently as you have it, [purple]your SQL is allowing all records to pass![/purple]

[blue]Post the SQL and we'll help you sort it out . . .[/blue]

See Ya! . . . . . .