[SQL] How can I simply substatue a value in a query?

2005-06-27 Thread Roy Souther
s a better way, somthing very simple but I cannot remember what it is. Roy Souther www.SiliconTao.com Let Open Source help your business move beyond. For security this message is digitally authenticated by GnuPG. signature.asc Description: This is a digitally signed message part

[SQL] Bad SUM result

2002-07-07 Thread Roy Souther
payment of $1 would return ($100+$100+$100)-($10+$15+$1) = $274. Could some one explain this to me and recommend an SQL command that would work please? I could do this using a temp table but that would be very messy as I would really like it to be a single SQL command. - -- Roy Souther <

[SQL] Who do I make _ not a wildcard?

2001-07-28 Thread Roy Souther
In PG the _ is a wildcard that means any singal char. I need to do a search for the actual _ char and not get back thousands of wrong matches. Is there and escape char that I could use? This needs to work with PG 7.0.3 & 7.1.2. TIA -- Roy Souther <[EMAIL PROTECTED]> 0110001

[SQL] SELECT * INTO TABLE is not working for me.

2001-05-30 Thread Roy Souther
the_stuff that works and makes a new table, but it causes other problems with the clients that this app is running from. I would like to make the SELECT * INTO work. Any idea? -- Roy Souther <[EMAIL PROTECTED]> 01100010 10101110 11000110 11010110 0100 10110010 10010110 11000110 01001110 11