using cast

Results 1 to 2 of 2

Thread: using cast

  1. #1
    Join Date
    Dec 1969

    Default using cast

    I have a field with a datatype of varchar with the values<BR> 1 1.1 1.2.1 <BR>etc. I am trying to use a cast to convert this field type to decimal using the cast function.The stored procedure compiles okay but executes with this error msg<BR><BR>Syntax error converting the varchar value &#039;6.2&#039; to a column of data type int.<BR><BR>Any suggestions

  2. #2
    Join Date
    Dec 1969

    Default RE: using cast

    Give a bit of your code.<BR><BR>Is the problem in your asp or your sp( in which case repost in DB Q&A)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts