Re: Converting a field from int to varchar during query
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 02/02/05
- Next message: Wendy W: "Re: Data style?"
- Previous message: Hugo Kornelis: "Re: copy table structure"
- In reply to: Jig Bhakta: "Converting a field from int to varchar during query"
- Next in thread: Jig Bhakta: "Re: Converting a field from int to varchar during query"
- Reply: Jig Bhakta: "Re: Converting a field from int to varchar during query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 02 Feb 2005 23:58:27 +0100
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)
- Next message: Wendy W: "Re: Data style?"
- Previous message: Hugo Kornelis: "Re: copy table structure"
- In reply to: Jig Bhakta: "Converting a field from int to varchar during query"
- Next in thread: Jig Bhakta: "Re: Converting a field from int to varchar during query"
- Reply: Jig Bhakta: "Re: Converting a field from int to varchar during query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
