SQL strings enable the application of advanced filters within SAP2000. The SQL string entered into SAP2000 corresponds to the portion of the full SQL Select Statement which follows the . To demonstrate, advanced filtering will be applied, using SQL strings, to the Joint Coordinates table of Verification Example 1-024 as follows:

Report 1

Report 1 selects all joints where the X coordinate is greater than 1.0, then organizes the data in order of XorR, Y, and Z coordinates using the SQL string which follows:

XorR > 0 ORDER BY XorR, Y, Z

The application of this advanced filter SQL string is shown in Figure 1:

Data is organized accordingly in the Joint Coordinates table, as shown in Figure 2:

Report 2

Report 2 selects all joints with a Z coordinate between 12 and 14, then organizes the data by XorR, Y, and Z coordinates using the SQL string which follows:

Z > 12 AND Z < 14 ORDER BY XorR, Y, Z

The application of this advanced filter SQL string is shown in Figure 3:

Data is organized accordingly in the Joint Coordinates table, as shown in Figure 4:

External Links

• - SQL tutorial by w3schools.com