SELECT stockNames FROM [its].[dbo].[stocks] WHERE stockNames LIKE '_NAS'
SELECT stockNames FROM [its].[dbo].[stocks] WHERE stockNames LIKE '%NAS%'
SELECT stockNames FROM [its].[dbo].[stocks] WHERE stockNames LIKE 'NAS%'