Gap Checking in Text and Numeric Fields? 1

[AshleyRickards]

Need to run gap reports on columns. Example entries would be alpha numeric like 'RM00001'. Multiple prefix's depending on type of document.
Also have numeric fields that need to be checked for gaps.

TIA Ashley L Rickards
SQL DBA

 

[tlbroadbent]

Check faq183-840. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[AshleyRickards]

Thanks Terry I'll work with this.
Ashley L Rickards
SQL DBA