Using escape sequence to find rows begining with %

[Java Tip]

The snippet below is used to find all rows that begins with the character "%".

st = con.createStatement();
rs = st.executeQuery
 ("SELECT value FROM vendors WHERE value LIKE '$%%' {escape '$'}");