List of most currency ISO code and symbol format in SQL.

gistfile1.txt

DROP TABLE currency;

-- Create table variable
CREATE TABLE currency (
  name   VARCHAR(20),
  code   VARCHAR(3),
  symbol VARCHAR(5)
);

ALTER TABLE currency CONVERT TO CHARACTER SET utf8;

-- Insert currency records
INSERT INTO currency (name, code, symbol) VALUES ('Leke', 'ALL', 'Lek');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'USD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Afghanis', 'AFN', '؋');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'ARS', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Guilders', 'AWG', 'ƒ');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'AUD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('New Manats', 'AZN', 'ман');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BSD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BBD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Rubles', 'BYR', 'p.');
INSERT INTO currency (name, code, symbol) VALUES ('Euro', 'EUR', '€');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BZD', 'BZ$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BMD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Bolivianos', 'BOB', '$b');
INSERT INTO currency (name, code, symbol) VALUES ('Convertible Marka', 'BAM', 'KM');
INSERT INTO currency (name, code, symbol) VALUES ('Pula', 'BWP', 'P');
INSERT INTO currency (name, code, symbol) VALUES ('Leva', 'BGN', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Reais', 'BRL', 'R$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GBP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BND', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Riels', 'KHR', '៛');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'CAD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'KYD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'CLP', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Yuan Renminbi', 'CNY', '¥');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'COP', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Colón', 'CRC', '₡');
INSERT INTO currency (name, code, symbol) VALUES ('Kuna', 'HRK', 'kn');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'CUP', '₱');
INSERT INTO currency (name, code, symbol) VALUES ('Koruny', 'CZK', 'Kč');
INSERT INTO currency (name, code, symbol) VALUES ('Kroner', 'DKK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'DOP ', 'RD$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'XCD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'EGP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Colones', 'SVC', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'FKP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'FJD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Cedis', 'GHC', '¢');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GIP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Quetzales', 'GTQ', 'Q');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GGP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'GYD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Lempiras', 'HNL', 'L');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'HKD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Forint', 'HUF', 'Ft');
INSERT INTO currency (name, code, symbol) VALUES ('Kronur', 'ISK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'INR', 'Rp');
INSERT INTO currency (name, code, symbol) VALUES ('Rupiahs', 'IDR', 'Rp');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'IRR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'IMP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('New Shekels', 'ILS', '₪');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'JMD', 'J$');
INSERT INTO currency (name, code, symbol) VALUES ('Yen', 'JPY', '¥');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'JEP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Tenge', 'KZT', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Won', 'KPW', '₩');
INSERT INTO currency (name, code, symbol) VALUES ('Won', 'KRW', '₩');
INSERT INTO currency (name, code, symbol) VALUES ('Soms', 'KGS', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Kips', 'LAK', '₭');
INSERT INTO currency (name, code, symbol) VALUES ('Lati', 'LVL', 'Ls');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'LBP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'LRD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Switzerland Francs', 'CHF', 'CHF');
INSERT INTO currency (name, code, symbol) VALUES ('Litai', 'LTL', 'Lt');
INSERT INTO currency (name, code, symbol) VALUES ('Denars', 'MKD', 'ден');
INSERT INTO currency (name, code, symbol) VALUES ('Ringgits', 'MYR', 'RM');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'MUR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'MXN', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Tugriks', 'MNT', '₮');
INSERT INTO currency (name, code, symbol) VALUES ('Meticais', 'MZN', 'MT');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'NAD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'NPR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Guilders', 'ANG', 'ƒ');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'NZD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Cordobas', 'NIO', 'C$');
INSERT INTO currency (name, code, symbol) VALUES ('Nairas', 'NGN', '₦');
INSERT INTO currency (name, code, symbol) VALUES ('Krone', 'NOK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'OMR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'PKR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Balboa', 'PAB', 'B/.');
INSERT INTO currency (name, code, symbol) VALUES ('Guarani', 'PYG', 'Gs');
INSERT INTO currency (name, code, symbol) VALUES ('Nuevos Soles', 'PEN', 'S/.');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'PHP', 'Php');
INSERT INTO currency (name, code, symbol) VALUES ('Zlotych', 'PLN', 'zł');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'QAR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('New Lei', 'RON', 'lei');
INSERT INTO currency (name, code, symbol) VALUES ('Rubles', 'RUB', 'руб');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'SHP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Riyals', 'SAR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Dinars', 'RSD', 'Дин.');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'SCR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SGD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SBD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Shillings', 'SOS', 'S');
INSERT INTO currency (name, code, symbol) VALUES ('Rand', 'ZAR', 'R');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'LKR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Kronor', 'SEK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SRD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'SYP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('New Dollars', 'TWD', 'NT$');
INSERT INTO currency (name, code, symbol) VALUES ('Baht', 'THB', '฿');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'TTD', 'TT$');
INSERT INTO currency (name, code, symbol) VALUES ('Lira', 'TRY', '₺');
INSERT INTO currency (name, code, symbol) VALUES ('Liras', 'TRL', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'TVD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Hryvnia', 'UAH', '₴');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'UYU', '$U');
INSERT INTO currency (name, code, symbol) VALUES ('Sums', 'UZS', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Bolivares Fuertes', 'VEF', 'Bs');
INSERT INTO currency (name, code, symbol) VALUES ('Dong', 'VND', '₫');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'YER', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Zimbabwe Dollars', 'ZWD', 'Z$');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'INR', '₹');

-- Select values from table                        
SELECT * FROM currency;

I needed a table where the CurrencyCode was the primary key and combined the above scripts to this:

CREATE TABLE [dbo].[Currency](
[CurrencyCode] nvarchar NOT NULL,
[CurrencyName] nvarchar NOT NULL,
[CurrencySymbol] nvarchar NULL,
[Country] nvarchar NOT NULL,
[Comments] varchar NULL,
CONSTRAINT [PK_Currency_1] PRIMARY KEY CLUSTERED
(
[CurrencyCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AED', N'UAE dirham', N'د.إ', N'United Arab Emirates', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AFN', N'Afghan afghani', N'؋', N'Afghanistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ALL', N'Albanian lek', N'Lek', N'Albania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AMD', N'Armenian dram', N'֏', N'Armenia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ANG', N'Netherlands Antillean guilder', N'ƒ', N'Curacao (Netherlands), Sint Maarten (Netherlands)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AOA', N'Angolan kwanza', N'Kz', N'Angola', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ARS', N'Argentine peso', N'$', N'Argentina', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AUD', N'Australian dollar', N'$', N'Australia, Christmas Island (Australia), Cocos (Keeling) Islands (Australia), Kiribati, Nauru, Norfolk Island (Australia), Tuvalu', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AWG', N'Aruban florin', N'ƒ', N'Aruba (Netherlands)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AZN', N'Azerbaijan manat', N'ман', N'Azerbaijan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BAM', N'Bosnia and Herzegovina convertible mark', N'KM', N'Bosnia and Herzegovina', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BBD', N'Barbadian dollar', N'$', N'Barbados', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BDT', N'Bangladeshi taka', N'৳', N'Bangladesh', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BGN', N'Bulgarian lev', N'лв', N'Bulgaria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BHD', N'Bahraini dinar', N'BD', N'Bahrain', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BIF', N'Burundi franc', N'FBu', N'Burundi', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BMD', N'Bermudian dollar', N'$', N'Bermuda (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BND', N'Brunei dollar', N'$', N'Brunei', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BOB', N'Bolivian boliviano', N'$b', N'Bolivia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BRL', N'Brazilian real', N'R$', N'Brazil', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BSD', N'Bahamian dollar', N'$', N'Bahamas', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BTN', N'Bhutanese ngultrum', NULL, N'Bhutan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BWP', N'Botswana pula', N'P', N'Botswana', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BYN', N'Belarusian ruble', NULL, N'Belarus', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BZD', N'Belize dollar', N'BZ$', N'Belize', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CAD', N'Canadian dollar', N'$', N'Canada', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CDF', N'Congolese franc', NULL, N'Congo, Democratic Republic of the', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CHF', N'Swiss franc', N'CHF', N'Liechtenstein, Switzerland', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CKD', N'Cook Islands dollar', NULL, N'Cook Islands (New Zealand)', N'This currency code is not part of the ISO 4217 standard, but is used commercially.')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CLP', N'Chilean peso', N'$', N'Chile', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CNY', N'Chinese Yuan Renminbi', N'¥', N'China', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'COP', N'Colombian peso', N'$', N'Colombia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CRC', N'Costa Rican colon', N'₡', N'Costa Rica', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CUP', N'Cuban peso', N'₱', N'Cuba', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CVE', N'Cape Verdean escudo', N'Esc', N'Cabo Verde', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CZK', N'Czech koruna', N'Kč', N'Czechia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DJF', N'Djiboutian franc', N'Fdj', N'Djibouti', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DKK', N'Danish krone', N'kr', N'Denmark, Greenland (Denmark)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DOP', N'Dominican peso', N'RD$', N'Dominican Republic', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DZD', N'Algerian dinar', N'DA', N'Algeria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'EGP', N'Egyptian pound', N'£', N'Egypt', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ERN', N'Eritrean nakfa', N'Nkf', N'Eritrea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ETB', N'Ethiopian birr', N'Br', N'Ethiopia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'EUR', N'European euro', N'€', N'Akrotiri and Dhekelia (UK), Aland Islands (Finland), Andorra, Austria, Belgium, Cyprus, Estonia, Finland, France, French Guiana (France), Germany, Greece, Guadeloupe (France), Ireland, Italy, Kosovo, Latvia, Lithuania, Luxembourg, Malta, Martinique (France), Mayotte (France), Monaco, Montenegro, Netherlands, Portugal, Reunion (France), Saint Barthelemy (France), Saint Martin (France), Saint Pierre and Miquelon (France), San Marino, Slovakia, Slovenia, Spain, Vatican City (Holy See)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'FJD', N'Fijian dollar', N'$', N'Fiji', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'FKP', N'Falkland Islands pound', N'£', N'Falkland Islands (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'FOK', N'Faroese krona', NULL, N'Faroe Islands (Denmark)', N'This currency code is not part of the ISO 4217 standard, but is used commercially.')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GBP', N'Pound sterling', N'£', N'South Georgia Island (UK), Tristan da Cunha (UK), United Kingdom', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GEL', N'Georgian lari', N'ლ', N'Georgia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GGP', N'Guernsey Pound', N'£', N'Guernsey (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GHS', N'Ghanaian cedi', N'GH₵', N'Ghana', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GIP', N'Gibraltar pound', N'£', N'Gibraltar (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GMD', N'Gambian dalasi', N'D', N'Gambia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GNF', N'Guinean franc', N'FG', N'Guinea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GTQ', N'Guatemalan quetzal', N'Q', N'Guatemala', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GYD', N'Guyanese dollar', N'$', N'Guyana', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HKD', N'Hong Kong dollar', N'$', N'Hong Kong (China)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HNL', N'Honduran lempira', N'L', N'Honduras', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HRK', N'Croatian kuna', N'kn', N'Croatia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HTG', N'Haitian gourde', NULL, N'Haiti', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HUF', N'Hungarian forint', N'Ft', N'Hungary', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IDR', N'Indonesian rupiah', N'Rp', N'Indonesia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ILS', N'Israeli new shekel', N'₪', N'Israel, Palestine', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IMP', N'Manx pound', N'£', N'Isle of Man (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'INR', N'Indian rupee', N'₹', N'India', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IQD', N'Iraqi dinar', N'ع.د', N'Iraq', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IRR', N'Iranian rial', N'﷼', N'Iran', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ISK', N'Icelandic krona', N'kr', N'Iceland', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JEP', N'Jersey pound', N'£', N'Jersey (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JMD', N'Jamaican dollar', N'J$', N'Jamaica', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JOD', N'Jordanian dinar', N'د.ا', N'Jordan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JPY', N'Japanese yen', N'¥', N'Japan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KES', N'Kenyan shilling', N'Ksh', N'Kenya', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KGS', N'Kyrgyzstani som', N'лв', N'Kyrgyzstan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KHR', N'Cambodian riel', N'៛', N'Cambodia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KMF', N'Comorian franc', N'CF', N'Comoros', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KPW', N'North Korean won', N'₩', N'North Korea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KRW', N'South Korean won', N'₩', N'South Korea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KWD', N'Kuwaiti dinar', N'د.ك', N'Kuwait', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KYD', N'Cayman Islands dollar', N'$', N'Cayman Islands (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KZT', N'Kazakhstani tenge', N'лв', N'Kazakhstan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LAK', N'Lao kip', N'₭', N'Laos', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LBP', N'Lebanese pound', N'£', N'Lebanon', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LKR', N'Sri Lankan rupee', N'₨', N'Sri Lanka', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LRD', N'Liberian dollar', N'$', N'Liberia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LSL', N'Lesotho loti', NULL, N'Lesotho', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LYD', N'Libyan dinar', N'ل.د', N'Libya', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MAD', N'Moroccan dirham', N'MAD', N'Morocco', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MDL', N'Moldovan leu', N'L', N'Moldova', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MGA', N'Malagasy ariary', N'Ar', N'Madagascar', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MKD', N'Macedonian denar', N'ден', N'North Macedonia (formerly Macedonia)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MMK', N'Myanmar kyat', N'K', N'Myanmar (formerly Burma)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MNT', N'Mongolian tugrik', N'₮', N'Mongolia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MOP', N'Macanese pataca', N'MOP$', N'Macau (China)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MRU', N'Mauritanian ouguiya', NULL, N'Mauritania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MUR', N'Mauritian rupee', N'₨', N'Mauritius', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MVR', N'Maldivian rufiyaa', N'Rf', N'Maldives', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MWK', N'Malawian kwacha', N'MK', N'Malawi', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MXN', N'Mexican peso', N'$', N'Mexico', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MYR', N'Malaysian ringgit', N'RM', N'Malaysia', N'')
GO
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MZN', N'Mozambican metical', N'MT', N'Mozambique', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NAD', N'Namibian dollar', N'$', N'Namibia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NGN', N'Nigerian naira', N'₦', N'Nigeria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NIO', N'Nicaraguan cordoba', N'C$', N'Nicaragua', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NOK', N'Norwegian krone', N'kr', N'Norway, Svalbard and Jan Mayen (Norway)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NPR', N'Nepalese rupee', N'₨', N'Nepal', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NZD', N'New Zealand dollar', N'$', N'Chatham Islands (New Zealand), New Zealand, Niue (New Zealand), Pitcairn Islands (UK), Tokelau (New Zealand)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'OMR', N'Omani rial', N'﷼', N'Oman', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PEN', N'Peruvian sol', N'S/.', N'Peru', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PGK', N'Papua New Guinean kina', N'K', N'Papua New Guinea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PHP', N'Philippine peso', N'Php', N'Philippines', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PKR', N'Pakistani rupee', N'₨', N'Pakistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PLN', N'Polish zloty', N'zł', N'Poland', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PYG', N'Paraguayan guarani', N'Gs', N'Paraguay', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'QAR', N'Qatari riyal', N'﷼', N'Qatar', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RON', N'Romanian leu', N'lei', N'Romania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RSD', N'Serbian dinar', N'Дин.', N'Serbia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RUB', N'Russian ruble', N'руб', N'Russia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RWF', N'Rwandan franc', N'R₣', N'Rwanda', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SAR', N'Saudi Arabian riyal', N'﷼', N'Saudi Arabia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SBD', N'Solomon Islands dollar', N'$', N'Solomon Islands', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SCR', N'Seychellois rupee', N'₨', N'Seychelles', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SDG', N'Sudanese pound', N'ج.س', N'Sudan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SEK', N'Swedish krona', N'kr', N'Sweden', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SGD', N'Singapore dollar', N'$', N'Singapore', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SHP', N'Saint Helena pound', N'£', N'Ascension Island (UK), Saint Helena (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SLL', N'Sierra Leonean leone', N'Le', N'Sierra Leone', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SOS', N'Somali shilling', N'S', N'Somalia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SRD', N'Surinamese dollar', N'$', N'Suriname', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SSP', N'South Sudanese pound', N'£', N'South Sudan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'STN', N'Sao Tome and Principe dobra', NULL, N'Sao Tome and Principe', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SYP', N'Syrian pound', N'£', N'Syria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SZL', N'Swazi lilangeni', N'L', N'Eswatini (formerly Swaziland)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'THB', N'Thai baht', N'฿', N'Thailand', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TJS', N'Tajikistani somoni', N'ЅM', N'Tajikistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TMT', N'Turkmen manat', N'T', N'Turkmenistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TND', N'Tunisian dinar', N'DT', N'Tunisia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TOP', N'Tongan pa’anga', N'T$', N'Tonga', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TRY', N'Turkish lira', N'₺', N'Turkey', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TTD', N'Trinidad and Tobago dollar', N'TT$', N'Trinidad and Tobago', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TWD', N'New Taiwan dollar', N'NT$', N'Taiwan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TZS', N'Tanzanian shilling', N'TSh', N'Tanzania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UAH', N'Ukrainian hryvnia', N'₴', N'Ukraine', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UGX', N'Ugandan shilling', N'USh', N'Uganda', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'USD', N'United States dollar', N'$', N'American Samoa (USA), Bonaire (Netherlands), British Indian Ocean Territory (UK), British Virgin Islands (UK), Caribbean Netherlands (Netherlands), Ecuador, El Salvador, Guam (USA), Marshall Islands, Micronesia, Northern Mariana Islands (USA), Palau, Panama, Puerto Rico (USA), Saba (Netherlands), Sint Eustatius (Netherlands), Timor-Leste, Turks and Caicos Islands (UK), United States of America, US Virgin Islands (USA), Wake Island (USA), Zimbabwe', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UYU', N'Uruguayan peso', N'$U', N'Uruguay', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UZS', N'Uzbekistani som', N'лв', N'Uzbekistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'VES', N'Venezuelan bolivar', NULL, N'Venezuela', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'VND', N'Vietnamese dong', N'₫', N'Vietnam', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'VUV', N'Vanuatu vatu', N'VT', N'Vanuatu', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'WST', N'Samoan tala', N'WS$', N'Samoa', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XAF', N'Central African CFA franc', N'FCFA', N'Cameroon, Central African Republic, Chad, Congo, Republic of the, Equatorial Guinea, Gabon', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XCD', N'East Caribbean dollar', N'$', N'Anguilla (UK), Antigua and Barbuda, Dominica, Grenada, Montserrat (UK), Saint Kitts and Nevis, Saint Lucia, Saint Vincent and the Grenadines', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XDR', N'SDR (Special Drawing Right)', NULL, N'International Monetary Fund (IMF)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XOF', N'West African CFA franc', N'CFA', N'Benin, Burkina Faso, Cote d''Ivoire, Guinea-Bissau, Mali, Niger, Senegal, Togo', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XPF', N'CFP franc', N'₣', N'French Polynesia (France), New Caledonia (France), Wallis and Futuna (France)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'YER', N'Yemeni rial', N'﷼', N'Yemen', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ZAR', N'South African rand', N'R', N'South Africa', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ZMW', N'Zambian kwacha', N'ZK', N'Zambia', N'')
GO