SqlFirst

This feature is free. Check out the awesome benefits of becoming a Pro User.

SqlFirst(string query) : string

Purpose

Returns the first column of the first row in the result of a 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 →