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

• Next in forum: Re: Joining tables in different databases
• Prev in forum: Re: Can i debug/watch on the trigger's INSERTED and DELETED records/values?
• Thread view: Re: select cast help needed

[Reply to this message]