pre values look up table

The below will not work because Key is a reserved word. I can't for the life of me figure out the work around for this.

I tried 'Key' , "Key", Key, [Key] 

SELECT * FROM tablename.sys_pre_values

WHERE Key = "MaritalStatus";

Appreciate any help on this... :)

P.

what are you getting that shows it does not work?

See correct statement below :

SELECT * FROM  `sys_pre_values` WHERE `Key` = 'MaritalStatus';

I have often wondered... Why the leading __ before the value.

Makes no sense....

Any ideas?

Peer

It's a language key. All language keys are prefixed with either 1 underscore _ or two underscores __

You will find many of the language keys used for pre values are prefixed with two underscores and all other language keys are just 1 underscore.

If you do a search in the languages for the key __Single you will find it.

Unless I am mistaken, that shows it is a language key that will get translated if you have other languages installed.

Geek Girl- That makes sense...

Thanks!

Peer

So, this is the query that works :)

SELECT  `Key`,`Value`, `Order`, SUBSTRING(lkey,3) as 'LKey'   FROM  `sys_pre_values` WHERE `Key` = 'MaritalStatus';

Thanks for all your help!

Peer