darksniperx Posted March 18, 2008 Share Posted March 18, 2008 I would like to do a query that selects field a,b,c. Trims field c, and ignores the whole record if field c is empty. something like this. SELECT A , B, trim('C') FROM TableA WHERE C != '' Any ideas on how to get the code work. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.