SQL

[stallion]

hi<br>
i have been asked to produce a telephone using VB6, i have only one problem, i have an address book facility where the name, number and address is entered into 3 separate text boxes and enterd into an Access 97 table via a recordset. I need to produce an SQL statement which will search the address book for the name belonging to the number that has just been dialed. This is a project i have been set and the reason this question sounds confusing is because the Examination Board that set this question are absolute idiots, who don't seem to know a thing about computing.<br>
thanks

 

[Karl Blessing]

if you just want the string<br>
&quot;select * from Table where Name = '&quot;& TheNameToSearch &&quot;'&quot;<br>
<p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML, ASP(somewhat), QBasic(least i didnt start with COBOL)