topic PARTIAL SEARCH ON A NUMERIC FIELD in Application Development and Automation Discussions

PARTIAL SEARCH ON A NUMERIC FIELD

Former Member — Fri, 28 Jan 2011 07:04:42 GMT

Hi,

i have one field zzoldwbs which is a numeric field. i want to have a wild card on that field like when a user enter 1* so all the data starting from 1 should be retrieved.the field have a data of 10digits and user can apply wild card on any digit .but i am failing to use wild card as it is very complicated so..how to use wild card on a numeric field.

Re: PARTIAL SEARCH ON A NUMERIC FIELD

Former Member — Fri, 28 Jan 2011 07:08:26 GMT

Hi,

write your numeric field value into a char field (length 10 chars) and search in this field!

Regards,

Klaus

Edited by: Klaus Babl on Jan 28, 2011 8:09 AM

Re: PARTIAL SEARCH ON A NUMERIC FIELD

Former Member — Fri, 28 Jan 2011 07:16:09 GMT

Hi,

No conversion is not possible as business requirement is that a user will enter only numeric values.

Re: PARTIAL SEARCH ON A NUMERIC FIELD

Former Member — Fri, 28 Jan 2011 07:21:07 GMT

Yes, you mustn't change your original field, but you can define a 10 char help field where you fill in your field content from your numeric field and search on this field! I don't think that your search wil be available in the numeric field, especially when you are looking for a (non-leading) 0 (zero).

Regards,

Klaus