detect character input

[evios]

Erm, how can i actualli detect certain word in a string so that i can accordingly insert them to the separate table in the database? For example:

xxxxxxxAxxxxx,xxxxx,xxxxx,xxxxxx,xxxxxx
xxxxxxxBxxxxx,xxxxx,xxxxx,xxxxxx,xxxxxx
........

xxxxxxAxxxxxx for table A
xxxxxxxBxxxxxx for table B?

thanks

[Jx_Man]

Ex :
Adam, ...,....,.... -> Table A

Bingo, ...,....,.... -> Table B

How if column value like this :
Dabo, ...,....,.... -> Table a or b?

[evios]

i knew what i am doing..onli either A or B within that string...thanks

[sierrainfo]

You can find info here:
http://msdn.microsoft.com/en-us/library/k78wd8wc.aspx

Regards
Sunil Punjabi
<snipped url>

[evios]

solved..thanks mate...

[sierrainfo]

You are welcome--Add to My Reputation if you like.. although it does not make a difference to me--it does make a difference to my Profile.

Regards
Sunil Punjabi
<snipped url>