SQL - Find columns in tables

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