multiple words separated by a space

jcwilkinson · Nov 28, 2005#12005-11-28T22:40+00:00

In SQL, the word "left" is used in 2 contexts: it is a string function, as in left(var_name, 2), and it is a statement, as in "select * from table1 left join table2 on .....".

Is there any way to set up syntax highlighting to distinguish these 2 uses? I have "left" defined as a function, and I tried defining "left join" as a statement, but it didn't work. Also it didn't work to define the function as "left(", I guess because the "(" is a delimiter. Any other ideas?

Mofi · Apr 29, 2006#22006-04-29T20:27+00:00

Because I don't like unanswered forum topics, here is the only possible answer for your problem.

There is no solution for your syntax highlighting problem if you do not plan to remove the "(" character from the list of delimiters which of course would not be a good idea.