Which Ulster player has fewer than 49 caps and plays the wing position?
CREATE TABLE table_name_4 (player VARCHAR, club_province VARCHAR, caps VARCHAR, position VARCHAR)
SELECT player FROM table_name_4 WHERE caps < 49 AND position = "wing" AND club_province = "ulster"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (player VARCHAR, club_province VARCHAR, caps VARCHAR, position VARCHAR) Question: Which Ulster player has fewer than 49 caps and plays the wing position? [/INST] SELECT player FROM table_name_4 WHERE caps < 49 AND position = "wing" AND club_province = "ulster" </s>