13.0.1400.15

Luis

I did use the code and it did work. I was just trying to change it to pull only the hexadecimal numbers in case they ask for them.

I am...

Luis

I did not create the table, I know they are hexadecimal numbers.

All I want to do is pull the records that are Decimal numbers not the hexadecimal numbers.

I hope this helps

CREATE TABLE [dbo].[BOOKTEMP1](

[SERIALNO] [int] IDENTITY(1,1) NOT NULL,

[RLDES] [nvarchar](10) NULL,

[TXID] [nvarchar](10) NULL,

[COMMSNO] [nvarchar](4) NULL,

[SYSNO] [nvarchar](4) NULL,

[ACCT] [nvarchar](12) NULL,

[DLR#] [nvarchar](12) NULL,

[CUST_NAME] [nvarchar](60) NULL,

[CLASSCODE] [nvarchar](5) NULL,

[COMMDATE] [nvarchar](11) NULL,

[DECOMDATE] [nvarchar](11) NULL,

[ACCT_STATE]...

I hope this helps

CREATE TABLE [dbo].[BOOKTEMP1](

[SERIALNO] [int] IDENTITY(1,1) NOT NULL,

[RLDES] [nvarchar](10) NULL,

[TXID] [nvarchar](10) NULL,

[COMMSNO] [nvarchar](4) NULL,

[SYSNO] [nvarchar](4) NULL,

[ACCT] [nvarchar](12) NULL,

[DLR#] [nvarchar](12) NULL,

[CUST_NAME] [nvarchar](60) NULL,

[CLASSCODE] [nvarchar](5) NULL,

[COMMDATE] [nvarchar](11) NULL,

[DECOMDATE] [nvarchar](11) NULL,

[ACCT_STATE]...

Jacob

looks like i posted that a little early it didn't work the alpha-numeric part.

SELECT*

FROMBOOKTEMP1

WHERE TXIDNOT LIKE '%[^0-f]%' and RLDES = '84'

I have changed the NOT LIKE to '%[^a-f]%'...

Jacob

Thank you so much, it worked great, I changed the '%[^0-f]%' to this to pull only Alpha-Numeric numbers it also worked geat.

Again thank you.