select cast syntax

[T.M.]

What is the correct syntax for querying the first 20 characters of a
memo field?

I'm trying to
SELECT CAST (varchar(20) fieldname) as newfieldname
and i get a bunch of errors

Can someone please help me?

MS Access DB used with ColdFusion

help would be greatly appreciated

[Dean]

Re: select cast syntax

Not sure about cold fusion, but in Access it is left$(fieldname ,20)

[Gox]

Re: select cast syntax

select mid([column_name], 1, 20) as newfieldname


T.M. wrote:[color=blue]
> What is the correct syntax for querying the first 20 characters of a
> memo field?
>
> I'm trying to
> SELECT CAST (varchar(20) fieldname) as newfieldname
> and i get a bunch of errors
>
> Can someone please help me?
>
> MS Access DB used with ColdFusion
>
> help would be greatly appreciated[/color]