Find all Tables that Contain a Specific Column Name in SQL Server

SELECT

    TABLE_CATALOG,

    TABLE_SCHEMA,

    TABLE_NAME,

    COLUMN_NAME,

    ORDINAL_POSITION as org_pos,

    DATA_TYPE,

    CHARACTER_MAXIMUM_LENGTH as CML

FROM

    INFORMATION_SCHEMA.COLUMNS

WHERE

    COLUMN_NAME LIKE '%Err%'

ORDER BY

    TABLE_NAME; 

special chars in xml

Replacing a & in XML correctly?

 " "

'   '
<   &lt;
>   &gt;
&   &amp;

List of XML and HTML character entity references - Wikipedia

Vlookup

 Example:

=VLOOKUP(F2, $A$2:$A$130, 1, FALSE)

single line IF statemt

 Ex:

 var vchr1099Xml = (eVoucherType == "Voucher Maintenance" ? "" : VoucherMapper.ConvertVchr1099ToXml(new Vchr1099 { Flag1099 = "N", Amount = e3EVoucher.voucher.Amount }));