assassinator
9th May 2008, 08:38
Now, I meet another problem.

Just like, I would like to see companies of all sizes of 4.3-inch glass. The size would describe in 'Item Description'.

So I run session tiitm0502m000(Display Item List), and choose 'Tools' -> 'Query'. Input like 'Item Description like .*4.3.*'. But the result come out as I input 'Item Description include '4' or '3'', not for 4.3.

I don't know how to query, when I use 'like' operator and the query contains the minority.

günther
9th May 2008, 11:41
Hi,

the query should be ".*4\.3.*".

Explanation:
"." means "any character".
".*" means "any character, 0 to n times", so that matches any leading things (and any trailing things as well).
"\." means "the point character itself".

Günther

assassinator
9th May 2008, 12:28
Hi,

the query should be ".*4\.3.*".

Explanation:
"." means "any character".
".*" means "any character, 0 to n times", so that matches any leading things (and any trailing things as well).
"\." means "the point character itself".

Günther

Yeah! I got it!! Really very useful!! Thank you very much!!