Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CAST....ANSI SQL

Status
Not open for further replies.
lucb

lucb

Technical User
Feb 4, 2004
1
FR
Is this statement:

Where substring(cast(date as varchar(8)),5,2) = '02'

ANSI SQL or is it MSSQL7 specific SQL?
 
Sort by date Sort by votes

The statement appears to be ANSI SQL compliant. Cast and substring as well as the date and varchar data types were included in the SQL-92 standard. Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
206
carp
carp
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
188
JarlH
JarlH
jm89
  • Locked
  • Question
Does this function follow ansi sql standard? 1
Replies
4
Views
178
JarlH
JarlH
soushi01
  • Locked
  • Question
Nested For Loop update statement (pl/sql) 1
Replies
2
Views
164
soushi01
soushi01
Pearlios
  • Locked
  • Question
SQL Keys and diagram
Replies
1
Views
121
r937
r937

Part and Inventory Search

Sponsor

Back
Top