Rik Wasmus schreef:
> On Thu, 01 May 2008 08:47:42 +0200, Rik Wasmus
> <luiheidsgoeroe@hotmail.com> wrote:
>> ÚPDATE data SET datefld = DATE(SUBSTRING(dateid,0,9);
>
> Ofcourse:
> ÚPDATE data SET datefld = DATE(SUBSTRING(dateid,0,8));

Of course:
ÚPDATE data SET datefld = DATE(SUBSTRING(dateid,1,8));

<docs http://tinyurl.com/7e7ve>
For all forms of SUBSTRING(), the position of the first character in the
string from which the substring is to be extracted is reckoned as 1.
</docs>
--
Luuk