Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jeremas
-
Field truncation on Interbase
I asked about field truncation as in other SQL standars you can use select right(message_min,10) from t1. It will return the 10 right side characters of the field. So with this I could truncate the field and create a temporary table to use join queries if possible. I will try your suggestion...- jeremas
- Post #3
- Forum: Embarcadero: InterBase
-
Field truncation on Interbase
Hello folks, I have two tables, one field of the first one is contained on one field of second table. I would like to have a query to get a count of fields where field.t1 is contained on field.t2. For example: Table t1 has field = numero_min = 5255585090333 and Table t2 has field =...- jeremas
- Thread
- Replies: 2
- Forum: Embarcadero: InterBase
