NJFBOA - Home of New Jersey's Camaros and Firebirds

NJFBOA - Home of New Jersey's Camaros and Firebirds (http://www.njfboa.org/forums/index.php)

- Lounge (http://www.njfboa.org/forums/forumdisplay.php?f=26)

- - Ugh, sometimes I just hate SQL! (http://www.njfboa.org/forums/showthread.php?t=47894)

JL8Jeff

11-06-2009 08:24 AM

Ugh, sometimes I just hate SQL!

I just spent 3 hours trying to get a query to run(yesterday afternoon and this morning) only to find out I just needed to add a single word to the original query. :-x But we actually have a bastardized SQL translator someone wrote so I thought it was something wrong with that. Now I can go and screw around with the VB, Access, Paradox, Java, VSS, HTML and everything else I'm supposed to know and support. :wink:

WildBillyT

11-06-2009 08:39 AM

That sucks. I hate the fact that SQL Server's LIKE wildcard is a '%' and it's a '*' in MS Access. Hey, Microsoft! They are both your ****ing products, and they both accept SQL syntax. Get on that.

JL8Jeff

11-06-2009 09:24 AM

Yeah, the wildcard thing throws off a lot of people.

bobb1589

11-06-2009 10:14 AM

Quote:

Originally Posted by WildBillyT (Post 651537)

That sucks. I hate the fact that SQL Server's LIKE wildcard is a '%' and it's a '*' in MS Access. Hey, Microsoft! They are both your ****ing products, and they both accept SQL syntax. Get on that.

they purposely make things different on Access...and personally, I think access is a joke. I think all other versions of SQL use the % as a wildcard

All times are GMT -5. The time now is 08:43 AM.