Searching Inventory By Description

kerrybros · Post by **kerrybros** » Thu Dec 11, 2014 4:21 am

Is it possible to search through your inventory by the description? I have tried using an * but am unsuccessful. I have had to organize my inventory by the first word and it is a PIA. Let me know thanks.

ricmorin · Post by **ricmorin** » Thu Dec 11, 2014 5:00 am

Yes you can. The wildcard character is %. So %tie as shown below will bring up all the records with tie in the description field.

: searchinv.png (37.75 KiB) Viewed 3572 times

Oh, and welcome to the forum.

kerrybros · Post by **kerrybros** » Thu Dec 11, 2014 5:40 am

Wow, Simple solution, Thanks a lot.

motley06 · Post by **motley06** » Thu Dec 11, 2014 7:48 pm

Just curious, it doesn't really make a difference, but does anyone know why we use a % symbol as a wild card and not an * like most other programs?

murraymotive · Post by **murraymotive** » Mon Dec 15, 2014 7:46 am

motley06 wrote:Just curious, it doesn't really make a difference, but does anyone know why we use a % symbol as a wild card and not an * like most other programs?

In SQL, % is a substitute for zero or more characters and _ is a substitute for a single character.

Searching Inventory By Description

Searching Inventory By Description

Re: Searching Inventory By Description

Re: Searching Inventory By Description

Re: Searching Inventory By Description

Re: Searching Inventory By Description