Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

Environ

Example

Retrieve a string containing the value of a specified operating system environment variable.

SELECT Environ(1);

Definition and Usage

The Environ() function returns a string with the value of a specified operating system environment variable.

Syntax

Environ(number)

OR:

Environ(string)

Parameter Values

Parameter

Description

number

The numerical position of the environment string within the environment-string table

string

The name of an environment variable

Technical Details

Works in:

From Access 2000