I am not sure you can that directly,
maybe could you try to convert in numeric on a first step ?
what is your ASE version ?
an old bug exist :
Title str() and convert from int to char obtain wrong results on 11.9.3 HP
Converting from integer to varchar results in wrong numbers for negative values. The bugfix of CR 204499 looks like 'done'. But the bugfix only fixed the converting from integer to CHAR. The problem is still existing for converting integer to VARCHAR
Even a indirect way would do.. A sp for this functionality.
Forgot to mention earlier...My ASE version is 12.5
TSQL suggests that there is a function isnumeric() but I am getting errors in using it.Does ASE 12.5 support this?
Could you please elaborate on how numeric conversion willhelp in resolving this?
The requirement is........
1)to find out all nonnumeric records from first table(A) and copy them to some other table(C) and continue with processing for table B....in simple terma just find all non numeric records from a varchar column.
Wonder...what a isinteger() built in would have done?