Re: Converting a field from int to varchar during query

From: Jig Bhakta (JigBhakta_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 13:01:08 -0800

Nope, still getting the error.

"Hugo Kornelis" wrote:

> On Wed, 2 Feb 2005 13:07:04 -0800, Jig Bhakta wrote:
>
> >I have a query where I am writing the following statement:
> >
> >select * from ......
> >where table1.field1 = table2.field2
> >....
> >....
> >....
> >
> >field2 is a varchar field and field1 is an int field. Field2 contains the
> >data mapping data for field1 and also other unrelated data as character
> >strings.
> >
> >How do I run this query without getting the error - "Syntax error converting
> >the varchar value 'XXXX' to a column of data type int."
>
> Hi Jignesh,
>
> Try:
>
> select * from ......
> where CAST(table1.field1 AS varchar(10)) = table2.field2
> .....
> .....
> .....
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>