Excel TSQL convert string to parameter - error “String Data, Right Truncation”.

[VA3GJG]

I have a SQL query using an ODBC DN connection that works.
However when I change the statement:

HAVING (InvMaster.StockCode = 'SJ8248009600')​

to use a parameter:

HAVING (InvMaster.StockCode = ?)​

Excel prompts me to link the parameter which is done successfully.
But upon refresh gives the error:

[Microsoft][ODBC SQL Server Driver]String Data, right truncation"​

The reference cell is formatted as text matching the SQL table field and the length of the cell value is the same as the value in the original SQL statement.
I've used this approach before many times but now this fails.

 

[Fazza]

I can't help on the specifics of why this has worked many times before but now fails. This sort of thing is never much fun.

I don't understand why the HAVING clause is used. What if you use a WHERE clause instead?