Concatenate number and string using in MSAccess using ODBiC
by Dave, November 9, 2003 00:06
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.
Name E-mail optional TopicMessage:
HTTP Link: Link text: