Posts by Kaleb Gabriel • 33 points
3 posts
-
0
votes1
answer418
viewsQ: Count the amount of my IF records
IF(Count(UCID)>1,Count(UCID),'0'), it brings me approximately 500 lines of record, being numbers of 2 above, I want to be able to make a COUNT in that IF to present those 500 in a column to part.…
-
0
votes3
answers353
viewsQ: Average time in seconds
Hello, in my select I need to find the average service time (TMA) between two columns BIGINT format being them: Date: Dtbegin (start) and Dtend (end) They are of the format "dd/mm/yyyyyy hh:mm:ss",…
-
2
votes1
answer1249
viewsQ: Find a numeric group in the string
Hello, I would like a help to locate a group of 20 numbers within a string that has characters and symbols. Let’s say my string has 165 characters, I want the numbers from 127 to 147 that are my…