Timeline for How to insert or escape single quotes at beginning and end of a null value or replace null with single quotes only
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 3, 2020 at 0:44 | comment | added | Sebastian Kessel | try now, please | |
| Mar 3, 2020 at 0:44 | history | edited | Sebastian Kessel | CC BY-SA 4.0 |
added 62 characters in body
|
| Mar 3, 2020 at 0:28 | comment | added | Sebastian Kessel | Explain it by giving examples in your original post. You've said the same thing three times and when two people helped you your only answer is "doesn't work". At this point, it is a matter of the problem not being properly defined. I will be available for a little longer if you can spend the time to expand. | |
| Mar 3, 2020 at 0:26 | comment | added | user58 | I expect just to see the single quotes only outputted. I don't know how else to explain it. The results are not showing any single quotes at all Example if have string of id i get this ('46734'.|'3435'). What I am looking for if no Ids then literally this ('') or (''|'') | |
| Mar 3, 2020 at 0:22 | comment | added | Sebastian Kessel | That is exactly what this string gives you. You're not being clear on EXACTLY what you expect (and why this "doesn't work"). I can't help you further until and unless you provide those details | |
| Mar 3, 2020 at 0:20 | comment | added | user58 | Thanks .This didn't work for me either. Im just for just singles quotes and nothing inbetween the single quotes if there is no Id. | |
| Mar 3, 2020 at 0:04 | history | answered | Sebastian Kessel | CC BY-SA 4.0 |