string sreach in columns

  • Thread starter Thread starter amy
  • Start date Start date
A

amy

Hi

How to sreach string in access
Like CALL NAME 'TOM' is in my access column
I want to just TOM from that string and keep into next
blank column adjacent to that column in the same row.

Please help me

AMY
 
How to sreach string in access
Like CALL NAME 'TOM' is in
my access column I want to just
TOM from that string and keep
into next blank column adjacent
to that column in the same row.

If you could be a little more specific, perhaps we could help... you need,
for example, to tell us what determines the particular text that you want to
extract from the column -- is it a word or words within single quotes, is it
the last word of text, or ??? Then, give us the name of the table, and the
names of the two columns, and maybe someone can suggest an approach...
update query, function, etc.

Larry Linson
Microsoft Access MVP
 
words within single quotes.

No It is in middle of text for example

123456'ABC'2345

SO I want to just ABC

AMY
 
Back
Top