I have also tried this approach (building my own loop).

The steps were:

Create a table (IdIndividual, IdMother, IdFather, Depth).

Create a sp with the parameters @IdIndividual, @Depth -> whithe the following...

Yes..I know 🙂

And I havepost it on Mysql forums, but it seems there isn't an easy way to do that.

There isn't any syntax in MySQL for extracting text using regular...

REGEXP is not ok for my case, because it will only return 1/0 (if the pattern is found inside the string or not) and it does not return the position...

I modified the function dbo.StripAlphaNumeric to also eliminate characters with ASCII code 192-> 252 because I have some of those there that I do not consider separators.

Then used the function...

I apologize for confusions.

I need the letters to.

What I do have is a text column with ingredients from certain recipes. And all the ingredients should be separated only by ','.

At...

Basically I need to find all the characters that are between one word and another.

So every character that is different from [a-z].

For example in a text like:

"4 filets de rascasses,<br...

Thank you for your answers.

I will keep the varchar column as it was and add a new table that will be populated with the types of dates.

Next I will add...

Thank you for your answer!

I am not allowed to change the column to datetime so that the users will not be restricted to a datetime column. The users will add...

Yes..I know..:)

The problem is I haven't created it, I just have to fix it..:)

Anyway, thank you for your reply!