Hi,

quote:

---

HI, I have face the same problem too last time. To get out of this trouble, i practise using yyy-mm-dd date format...

quote:

---

When is mysql v5 due out?

---

I think at this moment nobody really knows this. Production...

Hi,

that's right, I think you only get 1,2,3 when you drop the identity column and create it again. But in most cases you can't do that. If you need an...

I didn't mean that you're stupid, but my question.

I've made the experience that I sometimes look for the complicated and oversee the obvious.

Cheers,

Frank

Hi,

another try,

DECLARE @text varchar(8000)

SELECT @text = <your_textfield> FROM <table>

IF len(@text)>0

PRINT 'HALLO'

ELSE

PRINT 'SCHADE'

Cheers,

Frank

Oops,

my mistake!

Should have been reading more careful. You cannot use CHARINDEX on textfields. I'll keep searching.

Cheers,

Frank

Edited by - a5xo3z1 on 05/16/2003 08:27:51 AM

Hi,

I've tested it on my Server (SQL2k) and it runs.

Stupid question: Is startdate a datetime field?

Cheers,

Frank

Hi,

is SQL Server Agent running?

under account with appropriate rights?

Cheers,

Frank

Hi,

if you mean by comment something like '/', '//', '/*' in your textfield you can use CHARINDEX or PATINDEX to check for existance. See BOL for details.

Cheers,

Frank

Hi,

could it be you're using a different collation order on SQL2k than on SQL7?

Cheers,

Frank

quote:

---

That makes sense. Hope you didn't pull too much hair out looking for it. First place I always check is the administrators...

quote:

---

Actually use bit for Y/N values. Less need to worry about data options not being in range.

---

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]