🚀 go-pugleaf

On Fri, 8 Jan 1999 06:45:48 +0200, "Robert" <me@u.com> wrote:

>Does SQL Server natively support the following functions in SQL: IIF,
>Sqrt, ^ (power), Abs, Random, Like?
>
>In other words, will it run the following without adding custom function
>libraries:
>
>SELECT ID FROM Test WHERE ((Abs(10-Test.Field1)<11) AND (Like("*elephant*,
>Test.Field2))) ORDER BY SQRt(Test.Field3^2+Test.Field4^2),Random([ID]);

If Microsoft SQL Server (or any database server, for that matter) supports
these functions, it would be as nonstandard syntax. Standard SQL, as
defined by the SQL-92 specification, does not include any of those
functions. I can guarantee that local SQL does not include any
implementation of these functions. InterBase does not either, but they
could be added using user-defined functions.

Standard SQL does include a LIKE predicate (not a function). It is used in
a manner similar to comparison operators. For example:

  SELECT *
  FROM YourTable
  WHERE LastName LIKE "Smi%"

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "I do most of my writing sitting down.
Technical Publications              That's where I shine."
INPRISE Corporation                         -- Robert Benchley (1889-1945)
http://www.inprise.com/delphi