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: views

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

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« May    
prosoxi.com, Proudly powered by WordPress.