Spliting A Zip +4
Feb 5, 2008
Can someone show me how I can split the Zip+4 in this query, if it can be done at all?
SELECT
RTrim([CLIENT TABLE].CITY)+' , '+RTrim([CLIENT TABLE].ST)+' '+RTrim([CLIENT TABLE].ZIP) AS [ADD],
RTrim([CLIENT TABLE].FN)+' '+RTrim([CLIENT TABLE].LN) AS NAME,
[CLIENT TABLE].MEMBER, [CLIENT TABLE].PIN,
[CLIENT TABLE].A1, [CLIENT TABLE].A2,
[CLIENT TABLE].MEMBER_CASE_STATUS,
[CLIENT TABLE].RELATION_CODE INTO [CLIENT TABLE 2]
FROM [CLIENT TABLE];
Thanks
View Replies
May 29, 2005
Hi, Would it be possible to get the first word from a sentance.
For example
Peter James would Return Peter.
John Michael would Return John etc.
The first word could range from 1 to 50 characters.
Regards
Pete
View 2 Replies
View Related
Sep 29, 2005
Hi
I have the field fullname in my database which is in the format
Mr John Smith
What I have been trying to do is to extract the Mr then the John then the Smith into 3 separate columns. Can anbody help please?
Thank you
Marcus
View 3 Replies
View Related
Sep 21, 2006
Hi!
The structure is like:
C query is based on 2 tables, A and B.
Then D form is created based on query C.
What I did:
Now I split table A to 2 tables, A1 and A2 which are indepandant from each other, and I updated query C to retrive data from A1 and A2.
Problem:
Then the form D which is based on C doesn't work properly.
Question:
Do I need to recreate a Query C because I split table A?
or do I need to recreate a From D because Query C is updated?
Thanks very much
View 2 Replies
View Related
Sep 10, 2004
I have a field in a table that looks like this:
hahafdhzuiwre8878878s
agahh87878jkjkkjk
etc...
there is no set length to the bits between the slashes.
I want to write a query that moves the data into a new table in three separate fields using the slashes as field separators.
Can anyone help ??
View 1 Replies
View Related
Jan 14, 2005
i have a field called Items, description
Items Description
1021 125BL/WH
1022 5RD
1023 1458BL/BU/YL
1024 2500GR
1025 5GR
i want to be able to split the numeric from the color code. and add make a new field with the color code, and then have the quantity as a record.
Any Help is apreciated
Mark
View 14 Replies
View Related
Sep 21, 2006
Hi!
The structure is like:
C query is based on 2 tables, A and B.
Then D form is created based on query C.
What I did:
Now I split table A to 2 tables, A1 and A2, which are independant from each other, and I updated query C to retrive data from A1 and A2.
Problem:
Then the form D which is based on C doesn't work properly.
Question:
Do I need to recreate a Query C because I split table A?
or do I need to recreate a From D because Query C is updated?
Thanks very much
View 4 Replies
View Related