trim

[masoud_amen]

Hi.I have a table with a field wich has these values:
Top Low-Carb Products
Top Fat-Burners
Top Fat-Burners
...

how can I get rid of "Top" at the beging of each row?
thanks

[Dan_Bracuk]

If your db has string functions, use one in your select clause.

[masoud_amen]

but I need to do it in the code.

[Newsgroup_User]

in code you could use mid() or right() functions...

but i would also, as Dan suggested, rather do it in the query using db's
string manipulation functions (in many dbs they have same names - MID(),
RIGHT()... check your db's sql syntax manual). then your db does the
work instead of cf = not wasting cf processing time.

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

[Dan_Bracuk]

The query in your sql is part of your code. But, the more I think about it, you probably want this logic

if the 1st four characters are "Top "
do something to get rid of it. RemoveChars might work.

[tclaremont]

<CFIF #Left(StringName,4)# = 'Top '>
<CFSET NewString = #Replace(StringName, "Top ", "")#>
<CFELSE>
<CFSET NewString = #StringName#>
</CFIF>

#NewString#

[masoud_amen]

thanks