February 15, 2011 at 12:33 am
[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value '06/130/p18' to data type int.
February 15, 2011 at 12:42 am
Why are You converting the value like '06/130/p18' this to int.what exactly your need is
February 15, 2011 at 1:09 am
I need it its part of a plant module am working on , do you suggest that i exclude it ??
February 15, 2011 at 1:55 am
Thank you I have solved it I had to cast 'xxxx' as a var char in the SQL Join 🙂
March 11, 2011 at 5:55 pm
Thanks you for the post.
Hi guys, Im a newbie. Nice to join this forum.
__________________
March 11, 2011 at 6:01 pm
Glad it's working.
Data types are important in SQL Server, and you were relying on some implicit conversion to match a date to a character. That doesn't always work, and it can be a source of frustration.
If you have numerical or date data being stored as, or compared to, character data, always use an explicit conversion.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply