SAP Web IDE SQL Select Statement does not work

[draschke]

Hi,

it's wild, I can't figure out what's wrong with the select statement.

If I use "Wert" in the Where Clause then I don't get any result, even though the value is there. (No error messages!)

Its a NVARCHAR(15).

SELECT TOP 1000
"KennzahlID",
"PatientID",
"Wert",
"Art"
FROM "TBASE.db.data::tbase.cds.Kennzahl" where  "Wert" =  '0041715436' and  "Art" = 'SAP-Kennzahl';

I'm able to do this Select for all the other columns from this table. Its a column table.

I tried also similar tables and there it works as I would expect.

Any ideas?

[virendra_raval · Accepted solution]

Hi Dirk,

I think the value might have space(s) in it. As the value is numeric can you please try without single quotes like "Wert" = 0041715436. If the column is of text, you may want to try it after get rid of the blank spaces.

[draschke · Accepted solution]

Thank you very much.

I was sure that I tried also this way yesterday, but maybe I don't. As you said, without the single quotes it works for me.

where  "Wert" =  41715436;