I looked at ISNUMERIC first but I don't think thats what you are after, but

this will work...

set nocount on

declare @test table (

MyData nvarchar(50) not null

)

insert @test values ( 'thisoneok' )

insert @test values ( 'has123numbers' )

declare @numbers table (

digit char(1) not null

)

insert @numbers values( '0' )

insert @numbers values( '1' )

insert @numbers values( '2' )

insert @numbers values( '3' )

insert @numbers values( '4' )

insert @numbers values( '5' )

insert @numbers values( '6' )

insert @numbers values( '7' )

insert @numbers values( '8' )

insert @numbers values( '9' )

select *,

has_numbers = case when exists (

select *

from @numbers n

where len( replace( t.MyData, n.digit, '' ) ) <>

len( t.MyData )

) then 'Y' else 'N' end

from @test t

--

Tony Rogerson

SQL Server MVP

http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL

Server Consultant

http://sqlserverfaq.com - free video tutorials

<ja*****@gmail.comwrote in message

news:11**********************@m73g2000cwd.googlegr oups.com...

>I have a text field in a table that contains number along with chars.

Is there a way i can write a query to show all the fields that contains

just Numbers or Char in a field??

TBALE Example

COL1 : COL2(nvarchar)

---------------------------

100 345G01

200 123456789

300 GQ9220