Re: querie assitance

2003-08-16 Thread Rob Yelvington
- Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Rob Yelvington" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 15, 2003 4:10 PM Subject: Re: querie assitance > At 15:52 -0500 8/15/03, Rob Yelvington wrote: > &

querie assitance

2003-08-15 Thread Rob Yelvington
I need some help with a query. I have two tables in one data base that both have a SSN field. The ssn field in one table contains slashes and the ssn field in the other does not. I know how to use CONCAT() and RIGHT(),MID(), and LEFT() on one of the ssn fields to obtain a result with digits only