Sql update

Den groft forsimplede version:

update Table1
set Kolonne1 = MID(Kolonne1,3,10000)
;

Kan du ikke forklare hvad MID(Kolonne1,3,10000) helt præcis gør?

Alle andre steder hedder det substring eller bare substr i vb access hedder det alstå mid.
Den tager en delstreng af en anden streng.
Jeg tror, ifølge syntaxen, at du bare kan nøjes med 3-tallet og droppe sidste parameter:

In Access, the Mid function extracts a substring from a string (starting at any position).

The syntax for the Mid function is:

Mid ( text, start_position, number_of_characters )

Text is the string that you wish to extract from.

Start_position indicates the position in the string that you will begin extracting from. The first position in the string is 1.

Number_of_characters indicates the number of characters that you wish to extract. If you omit this parameter, the Mid function will return all characters after the start_position.



For example:

Mid ("Tech on the Net", 1, 4) would return "Tech"
Mid ("Alphabet", 5, 2) would return "ab"
Mid ("Alphabet", 5) would return "abet"