Determine the position of a char in a string 1

[LonnieJohnson]

Is there anyway I can determine the position of a character in a set of characters in a column.

For example if MyField had the following data how could I determine what position the X was in using T_SQL?

123Xkk
iX4444
PpX2i7

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[vbkris]

charindex() function is wht you are looking for...

Known is handfull, Unknown is worldfull

 

[vbkris]

from BOL:


CHARINDEX ( expression1 , expression2 [ , start_location ] )



Known is handfull, Unknown is worldfull

 

[LonnieJohnson]

This is exactly what I was looking for. I searched the BOL for different string manipulation functions and did not see this.

You are the man!

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[vbkris]

welcome...

Known is handfull, Unknown is worldfull