Hi - I am a newbie to Access & SQL and I would appreciate some help on
this if at all possible.
I have a query that contains the following code.
SELECT DISTINCT Product.[Short description] AS [Product Name],
Product.[Full description] AS [Product Description] ;
The problem I have is that the Product.[Full description] contains
characters that I do not want displayed in the query but are required
in the database. Therefore I want to replace !!<<ul>, <li> and
</ul>>!! with nulls and replace </li> with a full stop (period) in the
query.
I believe that this cannot be done directly in access but requires a
function to be created.
Can anyone point me in the right direction?