SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) 
 Jul 25 2020 11:26:55 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE Countries
(Country VARCHAR(100),
Continent VARCHAR(20)
)
;
INSERT INTO  Countries
VALUES ('UK','Europe'),('France','Europe'),('Portugal','Europe'),
('USA','North America'),('Canada','North America'),
('Brazil','South America'),('Peru','South America')
;

CREATE TABLE Orders
(OrderID INT IDENTITY PRIMARY KEY,
OrderDate DATE,
ShipCity VARCHAR(100),
ShipCountry VARCHAR(100)
)
;
INSERT INTO Orders (OrderDate, ShipCity, ShipCountry)
    VALUES (GETDATE(), 'London', 'UK'),
    (GETDATE(),'Paris','France'),
    (GETDATE(),'Porto','Portugal'),
    (GETDATE(),'Vale','USA'),
    (GETDATE(),'Cusco','Peru'),
    (GETDATE(),'Montreal','Canada'),
    (GETDATE(),'Rio de Janeiro','Brazil')
;
14 rows affected

select * from orders;


OrderID
OrderDate
ShipCity
ShipCountry


1
2022-08-08
London
UK

2
2022-08-08
Paris
France

3
2022-08-08
Porto
Portugal

4
2022-08-08
Vale
USA

5
2022-08-08
Cusco
Peru

6
2022-08-08
Montreal
Canada

7
2022-08-08
Rio de Janeiro
Brazil


DECLARE @Country VARCHAR(100) = '<Europe>';

SELECT o.* 
FROM Orders o
INNER JOIN Countries c ON c.Country = o.ShipCountry
WHERE o.ShipCountry = @Country
   OR c.Continent = REPLACE(REPLACE(@Country,'<',''),'>','')


OrderID
OrderDate
ShipCity
ShipCountry


1
2022-08-08
London
UK

2
2022-08-08
Paris
France

3
2022-08-08
Porto
Portugal


DECLARE @Country VARCHAR(100) = 'France';

SELECT o.* 
FROM Orders o
INNER JOIN Countries c ON c.Country = o.ShipCountry
WHERE o.ShipCountry = @Country
   OR c.Continent = REPLACE(REPLACE(@Country,'<',''),'>','')


OrderID
OrderDate
ShipCity
ShipCountry


2
2022-08-08
Paris
France

OrderID	OrderDate	ShipCity	ShipCountry
1	2022-08-08	London	UK
2	2022-08-08	Paris	France
3	2022-08-08	Porto	Portugal
4	2022-08-08	Vale	USA
5	2022-08-08	Cusco	Peru
6	2022-08-08	Montreal	Canada
7	2022-08-08	Rio de Janeiro	Brazil