Recent content by PIerre Chouinard

Dan yes you can send you project pchouinard[at]nostratek.com

Let's face the problem deffirently. Can we do a Lookup on the Database, by a value ending By. Lets Say scanned Barcode 123456 and the database 00000000123456 it will find it...

Corey your solution worked, but only if the raw data is always at the same length. By padding a value, this value should always keep the same length By example if we want 14 chararacters with Leading Zeros 1 is 00000000000001 and 123456 is 00000000123456

Maybe I missing something it only show 0 (zero)

Looking for Custom SQL documentation, This SQL return the number 6 do not know what it means...

I was thinking of using Sql Custom command like this: SELECT REPLACE('0',14-LEN(Field1))+Field1 FROM Session1 WHERE Field1='[*0*]' (Those functions are supported in SQL COmpact) In the Select it will padd the field and do the lookup on it....(14 is the length of my SKU number field) Make sense?

My database has Leading Zero on the Sku number. How can add Leading Zero to The barcode Scanned? Because when I try to lookup on it it does not work. Thanks