Mid( ) i stored procedure ?

du skal nok bruge substring() istedet, men ellers er det stort set det samme

Ja du skal bruge substring. Se hvordan den virker herunder:

SUBSTRING
Returns part of a character, binary, text, or image expression. For more information about the valid Microsoft® SQL Server™ data types that can be used with this function, see Data Types.

Syntax
SUBSTRING ( expression , start , length )

Arguments

Expression:
Is a character string, binary string, text, image, a column, or an expression that includes a column. Do not use expressions that include aggregate functions.

Start:
Is an integer that specifies where the substring begins.

Length:
Is an integer that specifies the length of the substring (the number of characters or bytes to return).