Useful Formula Use to Find the particular Column in a Table (SQL) SSMS

Select t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name As column_name
FROM sys.tables AS t
INNER JOIN sys.columns c on t.OBJECT_ID = C.OBJECT_ID
WHERE c.name LIKE '%Property%'
ORDER BY schema_name, table_name;


SELECT      COLUMN_NAME AS 'ColumnName'
            ,TABLE_NAME AS  'TableName'
FROM        INFORMATION_SCHEMA.COLUMNS
WHERE       COLUMN_NAME LIKE '%property%'
ORDER BY    TableName
            ,ColumnName;


------------------------------------------------------------------------
Trim the Date
CONCAT (
ltrim(rtrim(ia.ISAGENTADDRESSLINE1TEXT))
,iif(ltrim(rtrim(ISAGENTADDRESSLINE2TEXT))='','',CHAR(10))
,ltrim(rtrim(ISAGENTADDRESSLINE2TEXT))
,iif(ltrim(rtrim(ISAGENTADDRESSLINE3TEXT))='','',CHAR(10))
,ltrim(rtrim(ISAGENTADDRESSLINE3TEXT))
,iif(ltrim(rtrim(ISAGENTADDRESSLINE4TEXT))='','',CHAR(10))
,ltrim(rtrim(ISAGENTADDRESSLINE4TEXT))
,iif(ltrim(rtrim(ISAGENTADDRESSLINE5TEXT))='','',CHAR(10))
,ltrim(rtrim(ISAGENTADDRESSLINE5TEXT))
,iif(ltrim(rtrim(ISAGENTADDRESSLINE6TEXT))='','',CHAR(10))
,ltrim(rtrim(ISAGENTADDRESSLINE6TEXT))
,' ' + ltrim(rtrim(ISAGENTCEOPOSTCODETEXT))) Address,