Like Comparison

[smeaggie]

Hello Everyone

I am using the like Comparison to get a result from a column in POSTGRESQL.
The problem is that i can't retrieve the records who are not beginning with the charachter A to Z. I've tried many things.

EXAMPLE:

select name from company where name ~* '[^A-Z]%';

Can Someone help

Thanks in Advance,

Chris

 

[ceco]

you've made a mix between the two ways I know ;-))

one way is (I'm not sure in which pg version it appears)

select name from company where name similar to '[^A-Z]%';

the other which should work any where is

select name from company where name ~ '^[^A-Z]';

 

[smeaggie]

Thank you it works well, i took the last one.

Chris