Working with leading 0's

[cjany]

I have a table with an identifier that has leading zeros and another table where the similar identifier does not have leading zeros. I'd like to use this identifier to link the two tables. How can I either add leading 0's or take away the leading zeros to compare the two tables accurately?

 

[SkipVought]

Hi,

Leading zeros is either a DISPLAY feature for a NUMBER or it is TEXT -- very different.

So which is it?

If it's TEXT, then
[tt]
Format([YourNumberID],"00000000")
[/tt]
for instance, for an 8 character identifier.

Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[PHV]

WHERE Val(Table1.TextField)=Table2.NumericField

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886