AM
To: CF-Talk
Subject: RE: conversion of Access datatypes in the query
Havnt tried this, but it might be possible to use CStr()... i.e.
CStr(integerfield) as sFoo
Or maybe the Cast(integerfield as varchar) altho Im not sure that will
work
HTH
-Original Message-
From: Matthew Small
This is from the tSql BOL, so I don't know if this will work w/Access or not.
CAST ( expression AS data_type )
E
- Original Message -
From: "Matthew Small" <[EMAIL PROTECTED]>
Hi everyone -
I need to be able to convert both a datetime field and an
integer field to strings in a query
Opps, I didn't see the Access requirement. The convert function is working
in SQL, I don't know about Access
- Original Message -
From: "Matthew Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 10:11 AM
/login.cfm
- Original Message -
From: "Matthew Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 10:11 AM
Subject: conversion of Access datatypes in the query
> Hi everyone -
> I need to be able to convert both a datet
-Talk
Subject: conversion of Access datatypes in the query
Hi everyone -
I need to be able to convert both a datetime field and an integer
field to strings in a query (for concatenation with a string
field) but I can't remember how to do it.
Select datetimefield + stringfield + integer
Hi everyone -
I need to be able to convert both a datetime field and an
integer field to strings in a query (for concatenation with a string
field) but I can't remember how to do it.
Select datetimefield + stringfield + integerfield as stringtype from
table
Any help?
Matthew Small
IT D
6 matches
Mail list logo