SQL Syntax Question

[J]

I have an SQL select statement that selects fields from a table and renames
them depending on certain criteria. The datatype of the original field is a
memo (adLongVarWchar) 65535. When the fields gets renamed, the type and
size become adVarWChar (255). This results in my data being truncated and
it contains unreadable control characters if the size of the data exceeds
255.

Can a size be specified in the AS clause?

Basic Syntax:

SELECT *, IIF(INSTR(`Description`, '*OPTION') > 0, `Description`)
AS `OPTIONDesc`, IIF(INSTR(`Description`,
'*OPTION') = 0, `Description`) AS `OPTIONNonDesc`
FROM `EstimateSpecs`
ORDER BY `Order`

I am working in a dataenvironment in vb6.

Thanks for any help with this!