Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Split SSN

Status
Not open for further replies.
surfbum3000

surfbum3000

Technical User
Aug 22, 2003
156
US
The table I am working with has the field SSN. I need to seperate the numbers to 3 seperate fields: SSN1, SSN2, SSN3. The data in the field SOC_SEC_NUM is without hyphens: 123456789. I tried

SSN1: Val(Left([SOC_SEC_NUM],3)) ; This works OK
SSN2: ?
SSN3: Val(Right([SOC_SEC_NUM],4)) ; This works OK

How do I get the 4th and 5th digits into one field?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Sumnor
  • Locked
  • Question
Expression to Split a String at First Number 2
Replies
8
Views
330
Sumnor
Sumnor
maggsz
  • Locked
  • Question
split delimited field into different rows 3
Replies
19
Views
347
maggsz
maggsz
1DMF
  • Locked
  • Question
Split CSV text in one column to multiple rows with count 1
Replies
18
Views
226
1DMF
1DMF
gripper111
  • Locked
  • Question
split string
Replies
6
Views
247
strongm
strongm
Pack10
  • Locked
  • Question
How would you determine if a split form contains 0 records 1
Replies
7
Views
201
Pack10
Pack10

Part and Inventory Search

Sponsor

Back
Top