View Single Post
Old May 14, 2008 | 01:46 PM
  #2  
Shonky's Avatar
Shonky
V6 Ka of Love
 
Joined: Jun 2004
Posts: 460
Likes: 0
From: South Wales
Default

Originally Posted by Chip-3Door
Total mental block here as not needed to do this for a while, whats the command to replace text in a variable on the way out (ie the equivalent of a javascript VAR.replace() type command)

Ie

Select Name.replace('Chip', 'Cunt') from Users

Its NOT that, just hopefully that should make sense as to what im trying to do!

replace(a.name, 'chip', 'cunt')
Reply