Skip to content

prosoxi.com

Attention in classroom

  • Programming
    • ASP / ASP.net
    • .htaccess
    • PHP
    • JavaScript – Ajax
    • Facebook
    • HTML – XHTML
    • MySQL
    • node js
    • CSS
    • SEO
    • Flash
  • Mobile / Tablet
    • ionic framework
    • Android
    • cordova
    • ios
  • Graphics
    • After Effects
  • OS
    • Windows
    • MAC
    • Linux
  • Network
    • Trixbox
    • Plesk
    • Dreambox
  • News
    • Hack
    • Tutorials
    • Tips & Tricks
    • promo codes

Tag Archives: coalesce

Concatenate and NULL/Blank fields

CONCAT() and RTRIM() both return NULL if any of their arguments are NULL. So CONCAT(‘xyz’, NULL) returns NULL. RTRIM(NULL) returns NULL. CONCAT(‘xyz’, NULL, ‘123’) returns NULL. coalesce(FIELD, ‘—‘)

Posted byProsoxi.com WebmasterDecember 18, 2010December 18, 2010Posted inMySQLTags: coalesce, concat, MySQL, viewsLeave a comment on Concatenate and NULL/Blank fields

Advertise

Whocallsme.gr Widget Lookup

September 2025
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
2930  
« May    
prosoxi.com, Proudly powered by WordPress.