SqlFirst

SqlFirst(string query) : string

Purpose

Returns the first column of the first row in the result of an SQL query.

Requires that you setup a ConnectionString in SeoTools.config.xml.

Works great together with Format.

=SqlFirst(Format("SELECT Id FROM Clients WHERE Email=’{0}’
 AND Password=’{1}’";A1:A2))

See

Related Functions


Get help with this function in the community →