Re: SQL Query

From: Satish Balusa (sbalusa_nospam_at_corillian.com)
Date: 02/19/04

Next message: Jen: "Re: reindex or update stat"
Previous message: Satish Balusa: "Re: Need help with SP for search"
In reply to: Rmsands: "SQL Query"
Next in thread: Steve Z: "Re: SQL Query"
Reply: Steve Z: "Re: SQL Query"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 18 Feb 2004 16:21:18 -0800

What is the datatype of the AreaCode? Possibly you have a Alphabet or a non
number that in the values that is causing this problem.

-- 
HTH
Satish Balusa
Corillian Corp.
"Rmsands" <anonymous@discussions.microsoft.com> wrote in message
news:71B57E7E-5CCD-4381-B329-93F07C6CB1CA@microsoft.com...
> I ran this:
>
>
> select (lastname + ', ' + firstname) as 'NAME',
>  (areacode + '-' + phone) as 'PHONE'
>  from friends
>  where areacode between 300 and 400
>
> This is the error I got after I ran it:
>
> Server: Msg 8115, Level 16, State 6, Line 1
> Arithmetic overflow error converting varchar to data type numeric.
>
>
>
>

Next message: Jen: "Re: reindex or update stat"
Previous message: Satish Balusa: "Re: Need help with SP for search"
In reply to: Rmsands: "SQL Query"
Next in thread: Steve Z: "Re: SQL Query"
Reply: Steve Z: "Re: SQL Query"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

SQL Query
... where areacode between 300 and 400 ... Arithmetic overflow error converting varchar to data type numeric. ...
(microsoft.public.sqlserver.server)
Re: SQl query
... from friends ... where areacode between 300 and 400 ... Arithmetic overflow error converting varchar to data type numeric. ...
(microsoft.public.sqlserver.server)