I have a view with a column ADVERTISER_NAME and it hold values like
MacMall Affiliate Advantage Network
Dell Home & Home Office
Buy.com USA and Buy.com CA
I want to define another column that should only get the characters of column ADVERTISER_NAME until the first occurance of a space
ie if the above value are as follows:
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.