Examples of useful DejaVU SQL Statements

Punctuation (full stop)	Source contains a full stop, target not	source like "*.*" and target_XXXX not like "*.*"
Punctuation (bracket)	Source contains a full stop, “(“ or “)” is missing in target	source like "*(*)*" AND ((target_XXXX like "*)*" and target_XXXX not like "*(*") OR (target_XXXX like "*(*" and target_XXXX not like "*)*"))
Punctuation (bracket)	“(“ or “)” is missing in target	(target_XXXX like "*(*" and target_XXXX not like "*)*") OR (source like "*)*" and target_XXXX not like "*)*")
Uppercase	Source starts with uppercase, target not (all segments must be translated)	((asc(left(Source,1)) between 97 and 122) AND (asc(left(Target_XXXX,1)) between 65 and 90)) OR ((asc(left(Source,1)) between 65 and 90) AND (asc(left(Target_XXXX,1)) between 97 and 122))
Edited today	Target segment has been edited today	LastModified_XXXX >= Date()
Character length	Number of characters in target is bigger than in source	LEN(target_XXXX) > LEN(source)
Character length	Number of characters in target is bigger than 42	LEN(Target_XXXX) > 42
Non translatable	Segments containing non translatable texts (product name or version, including numbers and letters. E.g.: “A3000IH”).	Source LIKE '*[0-9][a-z]*' OR Source LIKE '*[a-z][0-9]*'
Double spacing	Target segments containing double spaces	Target_XXXX like "*  *"
Source = Target	Source and target segments are identical	target_XXXX = source