topic Re: wildcard search for numeric values using select ? in Application Development and Automation Discussions

wildcard search for numeric values using select ?

former_member31961 — Wed, 19 Dec 2007 08:51:37 GMT

Hi,

I want do wildcard search for numeric fields of the table.

For charcter/string i have used - select * from XX_TABLE where param1 like 'SS%'. But this query doesnt work when para1 is numeric. Please let me know first whether this is possible ? if yes how to achieve it ?

Thanks in advance,

Shrinivas

Re: wildcard search for numeric values using select ?

JackGraus — Wed, 19 Dec 2007 08:57:18 GMT

Numeric fields can not be like 'SS' so i think you want to select something like '66' ? For that youw might use something like 'where param1 between 660000 and 669999'.

regards Jack

Re: wildcard search for numeric values using select ?

former_member31961 — Wed, 19 Dec 2007 09:04:41 GMT

Hi Jack,

The numeric field is of 8 digits, so when i give search critera as '66', it should return values 66000000, 660000, 6600 etc. so i was not able to give between some range. I also tried storing all these values in internal table and the segregate the values it contains '66*'. This worked well but requires lot of coding effort.Please suggest if you guys have any better method ?

Thanks,

Shrinivas

Re: wildcard search for numeric values using select ?

Former Member — Wed, 19 Dec 2007 09:13:26 GMT

Hi,

Try this option.

select * from XX_TABLE where param1+0(2) = 'SS'.

- Selva