Simulated Function in SQL 7.0 - Microsoft SQL / MS SQL Server

[solex]

Hello,

What is the best way to simulate a function in SQL 7.0? The function I have
in mind would return a scalar value based on some input parameters. I would
like to call the function from within another SQL statement.

Thanks,
Dan

[solex]

Mohanjit,

Thanks for the quick response, but I should have been clearer in my need.
Basically I want to write a function that will format an address and be able
to include the function call in a batch update as in:

UPDATE Contacts
SET address = FormatAddress(g.Line1, g.Line2, g.City, g.State, g.Zip,
g.Country)
FROM Contacts c, GContacts g
WHERE c.ContactID = g.ContactID

"Mohanjit" <uc.edu> wrote in message
news:phx.gbl... 
> have 
> would 
>
>[/ref]

[Joe]

>> I want to write a function that will format an address and be able to
include the function call in a batch update <<

If you mean format an address for output or display, you are supposed to
be doing that in the front end, not the database. That is the whole
idea of a client/server architecture.

If you mean scrub address data for entry into the database, then I'd get
a commercial mailing product that will put them in to standard USPS
format. It is harder than it looks!

--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!