ODBiC Discussion Board

Concatenate number and string using in MSAccess using ODBiC

by Dave, November 9, 2003 00:06

Hello -

How can I go about concatenating a currency field and/or numeric filed and text? For example: Hello <name>, you have <$.$$ value> on your account. SQL Server has cast and convert functionality that works well,

CAST ( expression AS data_type )

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

but I can't seem to get anything working in ODBiC. Any help would be much appreciated.

Thanks, Dave


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 

Copyright ©1997-2003, Roger Harris. All rights reserved.