>>>>It's just a way of combining a GUID and a date to create a 'pseudo' GUID which will order by date. I don't see any reason why it would not work in CE - but there's no point unless you need the ordering. I'd also be concerned that MS might change the way a GUID is constructed in a future version - I think they've already changed it once....
>>>>Best,
>>>>Viv
>>>
>>>Hi Viv,
>>>
>>>CE doesn't support this function, it seems.
>>
>>Which bit are you referring to. It supports GUID's. The rest is just an algorithm to modify it using a date......
>
>I mean I tried changing the GUID field in SQL Server Compact Edition to use NewSequentialID() as default value and it gave me a message that it's wrong function name or something along the lines.
>
>Of course, I could have used the C# algorithm in my code to insert sequential GUID this way.

Ah, I thought we were talking about C# code. I've no idea which subset of SQL syntax is supported by SQL CE...