Converting a number to Text

Hi,

I'm having a tough time with my SQL statement when I try to join two
table. One table has a field named doc_no and is numeric while the
other table has a field named record_key and is text. When i write
"doc_no = record_key" and run the report, I get an error message about
data types not being equal.

How can I force the doc_no to be casted as text so I can join the
tables?

Please Help. Thank You,

Chaim Bochner

.

Relevant Pages

  • Re: Converting a number to Text
    ... I'm having a tough time with my SQL statement when I try to join two ... your text is not very long, if all you expect to do with it is to compare it ... comparing different data types (and in particular, ...
    (comp.databases.informix)
  • Re: Inserting empty items into a field.
    ... DENSITY] are double data types.) ... empty/null. ... deleting the entry in those fields but how do I do it with the SQL statement. ... MVP ...
    (microsoft.public.access.modulesdaovba)
  • Insert problem !!
    ... I am having an insert problem with values of different data types. ... table with String int & decimal data types. ... trouble building the SQL statement ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL statement question
    ... I am updating a table using the following SQL statement: ... They are both text data types. ... are supposed to be two digits. ...
    (microsoft.public.access.formscoding)