Limit the Number of Characters Returned

[d088]

I am running into a problem with a dynamically created Select Box being too
wide due to the names included in it. How can I limit the length of the
characters returned to keep the length of the select box to a certain size?

[TurboMini]

two ways. 1.) limit the size of the elements in your SQL query Left(value,25)
for SQL Server or Access, but differs for other databases 2.) limit the size
of the elements when you write the select box with CF: <option
value='#value#'>#Left(value,25)#</option>

[Unregistered]

The easiest way is to handle the issue on the query on your CF code. If your field needs to be trimmed on the right or left you can use the following syntax:

Remove empty spaces on the left side of the returned data of a field
SELECT field1, LTRIM(field2) as field2
FROM yourtable

Remove empty spaces on the rigth side of the returned data of a field
SELECT field1, RTRIM(field2) as field2
FROM yourtable