SQL Apprentice Question
Is there a way to in SQL to sort outline numbers to retain the
"natural order" state?
Shows up now as:
Is there any way to use recursive functionality to check for longer
outline numbers (i.e., like 220.127.116.11.1)?
>> Is there a way to in SQL to sort outline numbers to retain the "natural order" state? <<
I use this system in my books and other things a lot. My solution is
to pad each section with leading zeros and hope I never have more than
You enforce this with LIKE predicates and ORs in the DDL rather than
trying to do it in the DML.