ColdFusion sez this is valid SQL

select * from speakers where left(speaker_last_name,1) >= 'N';

which psql doesn't like

is this really SQL standard or really an oracle thing?

i know you can do a better job with

select * from speakers where speaker_last_name ~* '^N';

the only reason I'm concerned is that our webmaster is working to
integrate ColdFusion apps with PSQL (which work great) however, she's a
real SQL novice (had to show her how to setup a sequence to map over to MS
Access 'auto' datatype) et al

-----------------------------------------------------------------------------
david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------