First page Back Continue Last page Overview Text


String concatenation varies widely between databases.

The SQL standard uses the double pipe, but Microsoft SQL Server uses the addition operator, and MySQL uses the CONCAT method.

With Sequel, the same ruby code works on all three databases.

You can either use the standard addition operator after transforming the object to an SQL string, or you can use the sql_string_join array method.