Re: Identifying character as digit, alpha, etc.

From: Gregory A. Larsen (greg.larsen_at_netzero.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 09:42:09 -0700

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)