select cast help !!!

#1

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

scott.x.lu · #2

hi,
Cast should be the following:
CAST (fieldname as varchar(20)) as fieldname

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

select cast help !!!

comp.database.ms-sqlserver comp.database.ms-sqlserver

select cast help !!! - 01-25-2006 , 07:34 PM

07-05-2006 , 01:26 AM