Which names got my colums in SAP HANA

[former_member529961]

Helo experts, I got a SAP HANA DB. I create a column calles Users which got Emails as property

When i run a SQL query like this:

SELECT * FROM "DB_3"."NewsletterDATA.User"

it works. I get the Users together with there Emails. But when i try to filter for Emails like this:

SELECT * FROM "DB_3"."NewsletterDATA.User" WHERE Email = "foo@bar"

then i get an error that Email not a property is.

[KonradZaleski]

You should use single quotes instead of double quotes for the filtered value. Meaning

Email = 'foo@bar'

[former_member529961]

Thanks Konrad, but this do not work.

[pfefferf · Accepted solution]

As you get an error that column Email is not defined, I think that the name has upper and lower case characters. You have to enclose the column name with double quotes, otherwise it is translated to upper case. And of course, like Konrad commented already, you have to enclose the filter value with single quotes instead of double quotes.

SELECT * FROM "DB_3"."NewsletterDATA.User" WHERE "Email" = 'foo@bar'

[jyothirmayee_s]

Hi,

Just check how column Email is defined.

Try SELECT Email FROM "DB_3"."NewsletterDATA.User"

Thanks,

Jothi