Re: Identifying character as digit, alpha, etc.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 12:48:31 -0400

With a caveat: it's not always entirely accurate.
http://www.aspfaq.com/2390 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Gregory A. Larsen" <greg.larsen@netzero.com> wrote in message
news:O8llO4aQEHA.1644@TK2MSFTNGP09.phx.gbl...
> You can use the ISNUMERIC function to determine if character data is a
> number.
>
> -- 
>
> --------------------------------------------------------------------------
--
> --------------------------------------------------------------------------
--
> ----
>
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Michael Bauers" <anonymous@discussions.microsoft.com> wrote in message
> news:2E140565-7EF5-4FF8-95D8-099A53B37398@microsoft.com...
> > Can transact SQL identify a character as being a digit or an alpha
> character?  What if the data is unicode?  What if the data is from a non
> ASCII code page?
> >
> > Thanks
>
>

Relevant Pages

  • Re: Conversion error
    ... text (character strings) before importing them into SQL ... I have defined all columns in the SQL Server ... all values properly to varchar. ... money data. ...
    (microsoft.public.sqlserver.dts)
  • Re: BULK COPY changes row order importing Text file
    ... Error = [ODBC SQL Server Driver]Invalid character value for cast ... BCP copy in failed ...
    (microsoft.public.sqlserver.programming)
  • RE: strange problem with sql
    ... The difference in the character _ and W is just one bit. ... There are other letters that are getting mistranslated: ... My onlly guess now is that there is a memory ... > that at one occassion the SQL Server executed was changed on one ...
    (microsoft.public.sqlserver.programming)
  • Re: MS Query Problem
    ... The reason SQL Server deals with it is because you can define fixed length ... The field is a 20 character text string which represents an industry code, ... It would be a very unusual circumstance to keep trailing spaces. ...
    (microsoft.public.access.queries)
  • RE: strange problem with sql
    ... The difference in the character _ and W is just one bit. ... There are other letters that are getting mistranslated: ... My onlly guess now is that there is a memory ... > that at one occassion the SQL Server executed was changed on one ...
    (microsoft.public.data.ado)