Jump to content

Cheeesenbranston

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Cheeesenbranston

  • Rank
    Newbie
  1. I found a much simpler solution using ((LENGTH(source_string)) - (LENGTH(REPLACE (source_string, "string_to_count", "")))) / ( LENGTH("string_to_count")) AS count_of_string
  2. I am trying to process a string which contains various data relating to an elearning record; Moodle SCORM suspend_data if you're familiar with it Since I do not have access to server side SQL/CLR functions through the Moodle interface, I am attempting to reference, and extract, the relevant information from the string by explicitly referencing the character locations of the information I need in the string and then converting them as required so they can be summed e.g. SELECT prefix_user.username,........ ((CASE(SUBSTRING(value_rep,237,1)) WHEN 'c' THEN 1 ELSE 0 END) + ........(CASE(SUBSTRIN
×
×
  • Create New...