String mani***tion

Last Post 06 May 2010 01:01 PM by Jason Love. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
GoodFella3993
New Member
New Member

--
06 May 2010 12:04 PM
I am trying to find a word in a string field and put it in another field.

IE:

String =  "Hello.  My name is Sam Smith"
Key word = "Smith"

So, I want to update the field to be "Hello.  My name is Sam "
Then, put the word "Smith" in a new field with in the row.

Any ideas?


Jason Love
New Member
New Member

--
06 May 2010 01:01 PM
BOL the REPLACE function.


Acceptable Use Policy
---