Thanks CyberKiwi! I have a similar question…
The table FormDefinitions is as follows:
xaoCode contains over 900 lines of VBScript code. So doing a basic SQL select isn't very helpful when I only want to view only parts of the VBScript code.
I would like to get SQL Server 2008 to display the xaoCode values from the start of the line…
where like ‘%'Determine part ID for Product version and installation - for base price lookup%’
and onwards for the first 500 characters