Thank you Julian,

I'll never use date-subtract anymore, allways DATEDIFF.

But I think this is allowed:

When I want to show a date

eg the last date that a customer must have paid:

. ...

Thanks,

I'll use your (2nd) solution.

Henk

I found out that

WHERE (DateDepart > 14 + DateTimeBooking)

gives no error.

I think the problem is that the subtraction of two dates is seen as a date value and when...

Luigi,

I tried your solution, but it didn't work.

I think the idee is good, but the %-signs are missing.

I tried:

SELECT *

FROM table

WHERE ' '+nums+'% ' LIKE ' ' + @InputVariable...

David (and Deepak) thank you for your explanation.

You asked: Why in EM?

That's because I try the SQL before giving it to a person who

uses it in a asp.net application....

Thank you David !!!

This is exactly wat I want, it works fine.

I used your code in the Query Analyser and it workes fine.

But when I use it in the Enterprise...

A column for each number would be the best solution, but it's another program (a CMS) that is filling the table, and it's not possible to change this.

I found this...

you can make this also from Enterprise Manager..

1- make a new database ..(and name it the same as the old crashed one)

2- right click on this DB and choose "All...

Garry and Allen Thank you for your help. With this help I found out that the name I had to support in the WITH MOVE was VineaDb_Data in stead of...

Gary, Using the Enterprise Manager I get tab General: Name VineaDb, Tab DataFiles: Filename VineaDb_Data. Could it be the Captital 'D' in 'VineaDb', I did use...

Gary thank you. I found this about the same lines in BOL, but the BOL example has an extra line between the BACKUP and RESTORE Line: RESTORE...

I found this: Carriage returns not converted to P/BR in HTML mode when posting a reply (Priority 2). I'll come back later with my question.

How to place a CR/LF. I have a lot of lines but the message accepts only a single line