Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Matching the fi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 30634 of 31576
Post > Topic >>

Matching the first 3 letters of the field

by nofear <eurolinux@[EMAIL PROTECTED] > Jul 2, 2008 at 07:35 AM

I have 2 tables with 1 field each
the filed of the fist table has a 3 digit number stored as text
and the field of the second table has a 6 digit number stored as text

I'd like to select each 6 digit number where the first 3 digits match
the field in the first table

I'm not sure If I can use the "LIKE"
 




 3 Posts in Topic:
Matching the first 3 letters of the field
nofear <eurolinux@[EMA  2008-07-02 07:35:48 
Re: Matching the first 3 letters of the field
"Allen Browne"   2008-07-02 23:20:02 
Re: Matching the first 3 letters of the field
nofear <eurolinux@[EMA  2008-07-02 09:55:22 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:18:55 CST 2008.