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!

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

Easy One (hope so)

Status
Not open for further replies.

Kherozen

Programmer
Jun 5, 2003
129
CA
Hi,
ok in a SQL query you need to put ' ' around string , # # around Date and WHAT around currency?!




jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.
 
to save time, without having a book in front of me, initially my thought would be this, i don't think currency needs to be enclosed in anything. just treat it as you would a numeric.
sorry if i'm off base. hope this helps.
 
thread701-583583

thread701-435609

thread701-522412

thread701-477587

These threads may give you some ideas. I do not know SQL; sorry!

"The potentialities of a language are so vast that we must wonder sometimes at ourselves: how do we manage to know so much?" Anthony Burgess, A Mouthful of Air
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top