Results 1 to 6 of 6
Apr 23, 2004, 11:34 #1
- Join Date
- Dec 2003
- 0 Post(s)
- 0 Thread(s)
How to select distinct variable using like...
I m trying to use select statement in order to select a distinct word like 'c', but in the database i only want to select c when it occurs on its own not when it appears in another word. eg i need to select the alphabet 'c' in 'the cat category is c' but not the 'c' in 'cat' or 'category'.
I have used the code below but this seem to count all 'c'
select set rsTypes2 = con.execute("SELECT COUNT(two) AS total FROM march where two like '%c%'")
any idea how to implement this