Posted by Hugo Kornelis on 01/26/06 22:54

On Wed, 25 Jan 2006 20:39:45 -0500, T.M. wrote:

>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

Hi T.M.,

For Access help, you might want to post to an Access group. This group
is for SQL Server. :-)

In SQL Server, you'd use

SELECT CAST(fieldname AS varchar(20)) AS newfieldname FROM tablename

I have no idea how well that would port to Access.

--
Hugo Kornelis, SQL Server MVP

[Back to original message]