... solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave:
-- DataSet1:
SELECT TOP 100
Reference, Forenames, Surname, DOB
FROM
PersonsTable
WHERE
(Reference ...
What?
This is a quick note to show you how to convert a given comma delimited string into a database table:
Given: "Title,Forenames,Surname"
Return:
ID Value
------ ----------------
...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.