var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Wildcards
Hi all this is my first post and probably a simple question but my knowledge isnt great so here goes.
In access when I start my query I want to search for a record that I specify and preferably part of a recod.
At the moment my Query looks something like this..
SELECT Contacts.NameFirst FROM Contacts WHERE ((Contacts.NameFirst Like "*" & [Enter First Name]));
The problem is this will bring up the data im looking for as long as i dont inlude the first letter. for example if OI wanted to find "station" then "tion" would find my record but "stat" would not.
It Does however find my record if I type the whole name e.g. "station"
Any help with this would be appreciated
Soryr if I put this question in the wrong area.