Comments by Eek Ten Bears

Eek Ten Bears 7-Oct-22 2:22am View

"\\" in your last comment hints at the next issue that might "appear unexpectedly" just as well you suggested that verbatim string there Griff

Eek Ten Bears 7-May-21 3:29am View

LOL I had this assignment in a college course about 35 years ago. Its word for word the same, I think someone's tutor has copied it from somewhere.

Its easy, its to make you think about how methods interact with objects. So start it, comment as you go, it'll come and if its wrong start again. Don't ask for us to do it though, that way you'll learn nothing.

Eek Ten Bears 25-Mar-21 4:56am View

Thanks Griff, that's an excellent article, clear easy to understand. It doesn't give me Author but we'll do that by hard-coding which on reflection might be more appropriate.

Eek Ten Bears 7-Jan-20 6:06am View

DUH my bad, I forgot the trivial case - either add an "AND sector = 2" or do this which is prettier but includes a pointless application of PATINDEX
where PATINDEX('%[^0123456789]2[^0123456789]%', sector) + PATINDEX('%[^0123456789]2', sector) + PATINDEX('2[^0123456789]%', sector) + PATINDEX('2', sector)> 0

Comments by Eek Ten Bears (Top 4 by date)