Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last four characters of a field
Message
 
 
To
17/10/2012 16:05:40
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01555203
Message ID:
01555206
Views:
42
>I need to obtain the proper syntax to do a query on a character field based on the last four characters. For example, the record could have this value in that field: ThisIsMyFileName.ext. Thus, I need to locate the .ext record.
MyColumn LIKE '%.ext'
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform