/* Created by free online sql formatter */

DECLARE  @state CHAR(25);

SET @state = N'Oregon';

SELECT Rtrim(firstname) + ' ' + Rtrim(lastname) AS name,
       city
FROM   humanresources.vemployee
WHERE  stateprovincename = @state;