Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

PARTIAL SEARCH ON A NUMERIC FIELD

Former Member

‎2011 Jan 28 7:04 AM

0 Likes
483

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.

3 REPLIES 3
Read only

Former Member

‎2011 Jan 28 7:08 AM

0 Likes
442

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

Read only

Former Member
In response to Former Member

‎2011 Jan 28 7:16 AM

0 Likes
442

Hi,

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

Read only

Former Member
In response to Former Member

‎2011 Jan 28 7:21 AM

0 Likes
442

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