I'm really new to SQL so please feel free to laugh at my ridiculous question. I am more than proficient with VBA and thought it would translate, however it doesn't always seem to be the case.
I have built a view and in it I need to filter by LIKE 'appropriate'. I have tried a variety of different ways and it keeps giving me NULL results, which isn't true because I exported to Excel and can see several results there.
I would be grateful if you could advise. At the moment it looks like this (cant include all statement due to data protection stuff)
WHERE (ARCHV_FLAG = N'n') AND (CREATE_DTTM > CONVERT(DATETIME, '2014-04-01 00:00:00', 102)) AND (DIM_LOOKUP_CASNT_TYPE_ID_DESC = N'case note') AND (TITLE = N'LIKE APPROPRIATE')
I realise this is probably simple, but I am getting more than a little frustrated at it not working and would be really grateful if someone could help!
Thanks in advance
Nic (hopelessly new to all this)
asked Mar 23, 2015 at 03:50 PM in Default
Do you mean
in other words, are you searching for an occurrence of 'appropriate' in the Title column?
answered Mar 23, 2015 at 03:52 PM
Kev Riley ♦♦