Posted by T.M. on 01/26/06 03:39

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

Thanks

• Next in forum: Re: Truncate table if exists
• Prev in forum: Truncate table if exists
• Thread view: select cast help needed

[Reply to this message]