thank you very much for that SQL-command.
SELECT CONVERT(decimal(15, 4), ISNULL(REPLACE(HERUMSATZWELT, ',', '.'), 0)) AS Expr1
WHERE (ISNUMERIC(REPLACE(HERUMSATZWELT, ',', '.')) = 1)
(please note the point I replaced) and it worked well.
Nevertheless there are some field which do not contain NULLS.
The ASCII(fieldname) gives me NULL as result.
So I guess this field is "not defined".
This is the reason why I' m worried about < 0.
All "undefined" went to "0".
Not very elegant but it worked...
the data are coming from a web-frontend into an access-db.
Obviosly the user don't have to fillout all questions and therefore
some fields remain empty.
Others change to "NULL".
I don't know why.
I imported the data to SQL server and
checked them with select distinct
I get two "empty" fields in the result.
One contains "NULL" the other "nothing" ???
I tried ASCII(fieldname) to search for "nonvisible" data but
this ASCII-command results in NULL.
When trying your command it fails because of this empty fields.
I checked the SQL online help and found the
NonEmpty function but that will not work within a sql-command
(in my view)
now it is time to go to a new years eve party...
I will try it again next year!!!
By the way...
your welcome = Ihr Willkommen
is very, very strange - hihi -
your welcome best fits in german - gern geschehen -
But I get the idea.
Thanks for your help and tons of fun the next hours....