Functions in SQL

Article View: borland.public.vdbase.data.sql

Article #208

Back to borland.public.vdbase.data.sql Previous Next

#208

From: Robert
Date: Fri, 08 Jan 1999 00:00

13 lines
794 bytes

Hi All

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]);

Thanks
Robert

Technical Details

Message-ID: <7749st$gqj6@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,bee70b039be8a781,start
X-Google-Attributes: gidff5a1,public
From: "Robert" <me@u.com>
Subject: Functions in SQL
Date: 1999/01/08
Message-ID: <7749st$gqj6@forums.borland.com>
X-Deja-AN: 430101945
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql