The following script allow you to list columns from within a tables using Column_Name filters.
SELECT * from information_schema.columns WHERE table_name = 'SalesInvoice' AND COLUMN_NAME LIKE 'L%' --AND Column_Name LIKE '%L%' ORDER BY COLUMN_NAME
The following script allow you to list columns from within a tables using Column_Name filters.
SELECT * from information_schema.columns WHERE table_name = 'SalesInvoice' AND COLUMN_NAME LIKE 'L%' --AND Column_Name LIKE '%L%' ORDER BY COLUMN_NAME