SQL error: conversion failed when converting nvarchar value

Question

I am attempting to write a fairly simple stored procedure but getting an error when I print @sql

set @where = ' where deliverydate between '''+ @FromDate + ''' and ''' + @ThruDate + ''''
set @where = @where + ' and custlocation = '+ @custlocationID + ''''

The error reads:

Conversion failed when converting the nvarchar value ' where deliverydate between '8/1/2013' and '8/20/2014' and custlocationID = ' to data type int.

@custlocationID is declared as int.

Can someone help with the apostrophes?

Guffa · Accepted Answer · 2014-09-18 20:14:45Z

2

It's not the apostrophes that causes the error message. You are trying to add a string and an integer, and that will implicily convert the string to an integer.

Cast the integer to a string before you concatenate them:

set @where = @where + ' and custlocation = ' + cast(@custlocationID as varchar)

answered Sep 18, 2014 at 20:14

Guffa

703k111 gold badges760 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL error: conversion failed when converting nvarchar value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related