>That only works if the abbreviation starts at the beginning a a new line.
Sorry I misread that part
>I want this to work when the abbreviation is typed in the WHERE clause of a SQL command. Something like:
>
>select * from mytable where obet< space bar>
>
>Since I want the Oracle syntax of BETWEEN, it would return:
>
>SomeFieldName BETWEEN l_value1 AND l_value2
>
>So I would enhance your code to prompt for the field name first, then the 2 values. This is excellent suggestion from your code. Thank you for that. Now if I can just get this to work within a line of code.
>
Sorry if I'm wrong, but as I remember you cannot use a Command for this. Try to use a function (TYPE = F), and use "(" instead of space bar
...where obet(
Regards
Herman