trim

Forum|Forum|17 years ago
May 6, 2008
4 replies
475 views

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

Getting started

This topic has been closed for replies.

M

masoud_amenAuthor

Known Participant

thanks

tclaremont

Inspiring

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

#NewString#

D

Dan_Bracuk

Inspiring

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.

D

Dan_Bracuk

Inspiring

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