Maybe erical already has two columns that keep the "home score and away score as two separate int fields", as Mark and Phil already commented. Then, the remaining part of the question would be whether it is possible to create a user-defined type for a separate string column that stores the match result for faster printing. So, the answer in this situation would be that yes, it is possible. If unsure about the syntax of the CREATE TYPE statement, it is documented at the following URL: https://msdn.microsoft.com/en-us/library/ms175007.aspx The following would be an example of how to do it: CREATE TYPE MatchType FROM [VARCHAR](5); DECLARE @Draw [MatchType]; SET @Draw = '00-00'; DECLARE @Final [MatchType]; SET @Final = '02-01'; SELECT @Draw AS [Draw Match] , @Final AS [Final Match Sample]; -- Draw Match Final Match Sample -- 00-00 02-01