How to get this value?

I think this should be your solution:


SELECT columnname
FROM tablename

<cfoutput query="queryname">
#ListGetAt(columnname,2,"_")#<br>
</cfoutput>

Hope this helps!

as Dan has suggested, this is best done on the db level, using your db's
built-in string manipulation functions. most databases has an array of
these functions you can use, like SUBSTR() or SUBSTRING() or
STRING_INDEX() etc etc - check you db manual for correct function to
use. then you query sql would look something like:

SELECT somecolumn, SUBSTR(somecolumn, ) AS somealias
FROM sometable

you could also get your desired output at output time using CF's
string/list functions like listlast():

SELECT somecolumn
FROM sometable

<cfoutput query="somequery">
#listlast(somecolumn, "_")#<br>
</cfoutput>

but it is much more efficient to do this on the db level...


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

If your db allows it, you can select substrings.