Re: [SQL] Returning only alphanumeric values from a query

2010-07-26 Thread Osvaldo Kussama
2010/7/26 Enrique Palacios : > HI everyone, > Im new here, this is my first mail and i would like to know how return from > a query only alphanumeric values and these symbols: ().,-% > Something like: > SELECT description FROM products WHERE productid = 5 > RESULT > == > X# PRODUCT %1.0/30(UN)

[SQL] Returning only alphanumeric values from a query

2010-07-26 Thread Enrique Palacios
HI everyone, Im new here, this is my first mail and i would like to know how return from a query only alphanumeric values and these symbols: ().,-% Something like: SELECT description FROM products WHERE productid = 5 RESULT == X# PRODUCT %1.0/30(UN) DESIRED RESULT == X PRODUCT %1

Re: [SQL] [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them

2010-07-26 Thread Torsten Zühlsdorff
Hey Dmitriy, thanks for your reply. I think, its would be better to use rule on update instead of the trigger in such case as you. I've played the whole weekend with the rule-system, but it didn't work for my case. I have a dynamic trigger, which takes cares about revision of rows for every