SQLOrderByClause (Type)

An SQL 'order by' clause.

Based On:

String

Minimum Length:

1

Maximum Length:

0

Must Match Regular Expression:

^\p{Alpha}\w*(?:[.]\w+)?(?:\s+(?:(?i:asc|desc)))?(?:\s*,\s*\p{Alpha}\w*(?:[.]\w+)?(?:\s+(?:(?i:asc|desc)))?)*$

Must Not Match Regular Expression:

(?i:(?:^(?:asc|desc)$)|^(?:asc|desc)(?:,|\s)|,\s*(?:asc|desc)$|,\s*(?:asc|desc)(?:,|\s))

Error Message:

Must be a valid SQL 'order by' clause.