How to get the substring from a String in ColdFusion

Question

How can I get the Substring in Coldfusion?

ex:- following is the String "Update Tablename set value=something where value2=thisone"

I want to get the Table name from the Str

how is it possible?

Note:- Table name is dynamic(i.e may be any charecters).

Thanks

Answer 1

updated:

You can probably use result = ListToArray(sql , " ") and then use the result[2]

also i believe you can do ListGetAt(sql, 2, " ")

Answer 2

try this also, some times table name should be two words

thanx