CODEWITHSUNDEEP
sqlsql-server
David Tunnell
David Tunnell

Reputation: 7542

Modifying column datatypes for select view

I have a relatively simple query:

SELECT ATTR.*
    FROM NDC_ATTR ATTR
INNER JOIN CONTRACT_NDC_BRG BRG
    ON ATTR.ITEM_ID = BRG.CONTRACT_NUM_VAL AND BRG.CONTRACT_NUM_VAL LIKE '%'+@CONTRACT_NUMBER+'%'

The JOIN is causing data type issues:

Conversion failed when converting the varchar value 'Testing' to data type int.

How can I change the incoming datatypes during the query so I can fix this issue?

Upvotes: 0

Views: 50

Answers (1)

Sparrow
Sparrow

Reputation: 2583

You can use CAST or CONVERT

Using CAST:

SELECT ATTR.*
    FROM NDC_ATTR ATTR
INNER JOIN CONTRACT_NDC_BRG BRG
    ON Cast(ATTR.ITEM_ID as varchar(500)) = BRG.CONTRACT_NUM_VAL AND BRG.CONTRACT_NUM_VAL LIKE '%'+@CONTRACT_NUMBER+'%'

Upvotes: 3

Related Questions